IDLE_TIME DEFAULT
SESSIONS_PER_USER 2
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
PRIVATE_SGA DEFAULT
COMPOSITE_LIMIT DEFAULT
PASSWORD_LIFE_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_LOCK_TIME DEFAULT
FAILED_LOGIN_ATTEMPTS DEFAULT
PASSWORD_VERIFY_FUNCTION DEFAULT

ALTER USER "SCOTT" PROFILE "POLLAS" IDENTIFIED BY "*******" ACCOUNT UNLOCK


CREATE ROLE "CONECTARSE" NOT IDENTIFIED
GRANT "CONNECT" TO "CONECTARSE"
GRANT "RESOURCE" TO "CONECTARSE"


GRANT "CONECTARSE" TO "SCOTT"
GRANT "DBA" TO "SCOTT"
ALTER USER "SCOTT" DEFAULT ROLE ALL

CREATE USER "USUARIONUEVO" PROFILE "DEFAULT" IDENTIFIED BY "*******" PASSWORD EXPIRE DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT "CONNECT" TO "USUARIONUEVO"

ALTER USER "SCOTT" QUOTA 1000 M ON "USERS"
REVOKE UNLIMITED TABLESPACE FROM "SCOTT"

CREATE USER "PRUEBA1" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT CREATE ANY TABLE TO "PRUEBA1"
GRANT "CONNECT" TO "PRUEBA1"

GRANT SELECT ON "SCOTT"."EMP" TO "PRUEBA1"