sql cod
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;
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
Curtidas 0