how can i grant privilege to new user [message #323256] |
Tue, 27 May 2008 23:21  |
sumanbangladesh
Messages: 17 Registered: April 2008 Location: Bangladesh
|
Junior Member |
|
|
hi
i login as SYSDBA and create a user by CREATE USER user1 IDENTIFIED BY password;
then to give session create privilege i enter GRANT CREATE SESSION TO user1;
and then enter grant sysdba to user1
now i can connect user1 but when im trying to create table following error occurs:
ORA-01031: insufficient privilege
can any one help me to overcome this?
Thanks in advance
Suman
|
|
|
|
|
|
|
|