Home » RDBMS Server » Server Administration » SYS user and its privileges (oracle 10g,solaris10)
SYS user and its privileges [message #411718] Mon, 06 July 2009 07:35 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member



Hi all,

How to confirm by query that the user which im currently using is not a SYS user and also do let me know what are the privileges SYS user is having?


Thanks in advance


Regards

Re: SYS user and its privileges [message #411721 is a reply to message #411718] Mon, 06 July 2009 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't put many useless empty lines in your post
2/ USER
3/ ALL privileges

Regards
Michel
Re: SYS user and its privileges [message #411734 is a reply to message #411721] Mon, 06 July 2009 08:46 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


how to check from the database end whether all privileges are available from a user when i asked to connect using new user?
Re: SYS user and its privileges [message #411739 is a reply to message #411734] Mon, 06 July 2009 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
session_privs

Regards
Michel
Re: SYS user and its privileges [message #412739 is a reply to message #411739] Sat, 11 July 2009 00:04 Go to previous message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member


Thanks michel Smile
Previous Topic: Oracle server on internal disk vs external disk or netApp disk
Next Topic: DATABASE LINK
Goto Forum:
  


Current Time: Thu Dec 08 02:07:34 CST 2016

Total time taken to generate the page: 0.14090 seconds