User Creation(Mirror Ram Account)

User Creation(Mirror Ram Account)

select username,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,PROFILE  from dba_users where username like upper('ram');

 

USERNAME                       DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE           PROFILE
------------------------------ ------------------------------ ------------------------------ ------------------------------
RAM                       USERS                          TEMP                           SECURITY

 

CREATE USER seetha IDENTIFIED BY welcome#1 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE temp quota unlimited on USERS PROFILE SECURITY;

 

 

 

nram> select * from dba_role_privs where grantee=upper('ram');