Home » RDBMS Server » Security » Privileges related problem
Privileges related problem [message #275873] Tue, 23 October 2007 02:30 Go to next message
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.
Re: Privileges related problem [message #275875 is a reply to message #275873] Tue, 23 October 2007 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Privileges related problem [message #275876 is a reply to message #275873] Tue, 23 October 2007 02:52 Go to previous message
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.
Previous Topic: Grant on BLOB
Next Topic: create sequence privileges
Goto Forum:
  


Current Time: Thu Mar 28 16:49:16 CDT 2024