DROP USER Est01 CASCADE;
CREATE USER Est01 IDENTIFIED BY est01
DEFAULT TABLESPACE centroinca
TEMPORARY TABLESPACE temporal
QUOTA UNLIMITED ON data;
CREATE ROLE estudiantes;
GRANT CREATE session, CREATE table, CREATE view,
CREATE procedure,CREATE synonym,
ALTER table, ALTER view, ALTER procedure,ALTER synonym,
DROP table, DROP view, DROP procedure,DROP synonym,
TO conn;
GRANT estudiante TO Est01;
CREATE USER Est01 IDENTIFIED BY est01
DEFAULT TABLESPACE centroinca
TEMPORARY TABLESPACE temporal
QUOTA UNLIMITED ON data;
CREATE ROLE estudiantes;
GRANT CREATE session, CREATE table, CREATE view,
CREATE procedure,CREATE synonym,
ALTER table, ALTER view, ALTER procedure,ALTER synonym,
DROP table, DROP view, DROP procedure,DROP synonym,
TO conn;
GRANT estudiante TO Est01;
No hay comentarios:
Publicar un comentario