SQL> select username from dba_users;
USERNAME
------------------------------
OUTLN
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP
7 rows selected.
SQL> create user u1 identified by u1;
User created.
SQL> select username from dba_users;
USERNAME
------------------------------
OUTLN
U1
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP
8 rows selected.
SQL> conn u1/u1;
ERROR:
ORA-01045: user U1 lacks CREATE SESSION privilege; logon denied
Warning: You are no longer connected to ORACLE.
SQL> grant connect,resource to u1;
Grant succeeded.
SQL> conn u1/u1;
Connected.
USERNAME
------------------------------
OUTLN
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP
7 rows selected.
SQL> create user u1 identified by u1;
User created.
SQL> select username from dba_users;
USERNAME
------------------------------
OUTLN
U1
SYS
SYSTEM
DIP
ORACLE_OCM
APPQOSSYS
DBSNMP
8 rows selected.
SQL> conn u1/u1;
ERROR:
ORA-01045: user U1 lacks CREATE SESSION privilege; logon denied
Warning: You are no longer connected to ORACLE.
SQL> grant connect,resource to u1;
Grant succeeded.
SQL> conn u1/u1;
Connected.
No comments:
Post a Comment