how should i grant connect , resource privilege to a user (without DBA privilege) [message #564317] |
Wed, 22 August 2012 10:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/8680f113ef843bf061ec37f0e4231112?s=64&d=mm&r=g) |
thiyagusham
Messages: 112 Registered: April 2012 Location: Chennai
|
Senior Member |
|
|
I am checking GRANTS option with LOGICAL BACK UP ( EXP/IMP) . I did following commands from initial stage. please see it.
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> grant create user ,drop user , lock any table to sam;
SQL> conn sam
Enter password:
Connected.
SQL> create user san identified by san;
User created
Initially user sam having CREATE USER privilege.
User sam trying to grant following privilege.
SQL> grant connect ,resource to san identified by san;
grant connect ,resource to san identified by san
* ERROR at line 1:
ORA-01031: insufficient privileges
SQL> grant create session to san;
grant create session to san
* ERROR at line 1:
ORA-01031: insufficient privileges
Quote:
** Is there any specific system privilege to grant ?? (without DBA privilege ) **
** I googled more than 1 hour could n't find out ... **
So i done finally with DBA privilege.
conn /as sysdba
SQL> grant dba to sam;
Grant succeeded.
SQL> conn sam
Enter password:
Connected.
SQL> grant connect ,resource to san identified by san;
Grant succeeded.
SQL> grant connect , resource to rose identified by rose;
Grant succeeded.
SQL> grant connect , resource to preeti identified by preeti;
Grant succeeded.
SQL> grant connect ,resource to san identified by san;
Grant succeeded.
Quote:
My question is without DBA privilege
how should i grant connect , resource privilege to user san connect to the database.
Thanks and Regards
Thiyagusham.G
|
|
|
|
|
|
|
|
|
|
|