Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

grant SYSDBA privilege to local user ( testing purpose ).*

JhilDec 14 2012 — edited Dec 16 2012
Hello DBAs

I want to grant SYSDBA privilege to user sam ( testing purpose ).


SQL> grant SYSDBA to sam;

Grant succeeded.

SQL> conn sam
Enter password:
Connected.

SQL> shut immediate;
ORA-01031: insufficient privileges
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2013
Added on Dec 14 2012
#general-database-discussions
12 comments
50,116 views