OraFAQ Forum: Security » Privileges related problem

Home » RDBMS Server » Security » Privileges related problem

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

Tue, 23 October 2007 02:30

dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad

Junior Member

Hi..,
I 've executed the following two SQL statements on my connected user
1)
select * from user_sys_privs
No Rows Selected
2)
select * from USER_ROLE_PRIVS;

USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- --- ------------------------------
ACM_DEV CONNECT NO YES NO
ACM_DEV RESOURCE NO YES NO

But with out a privilege like "Alter Session" also the following statement is executing well
alter session set nls_date_format='DD-MM-YY'

The problem might be what can u please explain..

Thanks in Advance
Giri K.Y.

Report message to a moderator

Re: Privileges related problem [message #275875 is a reply to message #275873]

Tue, 23 October 2007 02:49

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Everybody that has CREATE SESSION can execute ALTER SESSION for a limited number of options; not all of them that requires ALTER SESSION privilege.
Among these options there is the setting of environment parameters.

Regards
Michel

Report message to a moderator

Re: Privileges related problem [message #275876 is a reply to message #275873]

Tue, 23 October 2007 02:52

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Read the document,
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#sthref4517

Quote:

To enable and disable the SQL trace facility, you must have ALTER SESSION system privilege.

To enable or disable resumable space allocation, you must have the RESUMABLE system privilege.

You do not need any privileges to perform the other operations of this statement unless otherwise indicated.

Report message to a moderator

Previous Topic:	Grant on BLOB
Next Topic:	create sequence privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 23:35:24 CST 2025