sql cod

SQL

Oracle

03/06/2024

create tablespace cursosql
datafile
'C:\ProgramData\Microsoft\Windows\StartMenu\Programs\Oracle-OraClient12Home1_32bit'
size 100m autoextend on next 50m maxsize 500m
online
permanent
extent management local autoallocate
segment space management auto;

-- criando usuario
create user aluno
identified by aluno
default tablespace curso
temporary tablespace TEMP;

-- permissao para aluno
grant create session, connect, resource to aluno;

alter user aluno quota unlimited on curso;
Carlos Miranda

Carlos Miranda

Curtidas 0
POSTAR