OraFAQ Forum: Server Administration » SYS user and its privileges

Home » RDBMS Server » Server Administration » SYS user and its privileges (oracle 10g,solaris10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYS user and its privileges [message #411718]

Mon, 06 July 2009 07:35

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

Report message to a moderator

Re: SYS user and its privileges [message #411721 is a reply to message #411718]

Mon, 06 July 2009 07:57

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: SYS user and its privileges [message #411734 is a reply to message #411721]

Mon, 06 July 2009 08:46

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?

Report message to a moderator

Re: SYS user and its privileges [message #411739 is a reply to message #411734]

Mon, 06 July 2009 08:58

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

session_privs

Regards
Michel

Report message to a moderator

Re: SYS user and its privileges [message #412739 is a reply to message #411739]

Sat, 11 July 2009 00:04

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Thanks michel Smile

Report message to a moderator

Previous Topic:	Oracle server on internal disk vs external disk or netApp disk
Next Topic:	DATABASE LINK

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:24:21 CDT 2024