OraFAQ Forum: Security » Privileges (merged)

Home » RDBMS Server » Security » Privileges (merged)

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

Privileges (merged) [message #388195]

Mon, 23 February 2009 15:08

varunvir
Messages: 389
Registered: November 2007

Senior Member

Hi Experts,
I created one database user bhdforacle and I granted role resource to bhdforacle.
When i do the following query:-
select * from dba_sys_privs where grantee='BHDFORACLE';
I can see only one privilege named UNLIMITED TABLESPACE.
while Resource has eight privileges and I dont see above
mentioned privilege owned by Resource
But when I run the following query:-
select * from dba_sys_privs where grantee='RESOURCE';
why both queries have different results.
Regards,
Varun Punj,

Report message to a moderator

Re: Privileges [message #388201 is a reply to message #388195]

Mon, 23 February 2009 16:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>why both queries have different results.
Because they are different SQL/queries.

Report message to a moderator

Re: Privileges [message #388202 is a reply to message #388195]

Mon, 23 February 2009 16:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

do not cross/multi-post

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Report message to a moderator

Re: Privileges [message #388205 is a reply to message #388201]

Mon, 23 February 2009 17:11

varunvir
Messages: 389
Registered: November 2007

Senior Member

Yeah Blackswan You are right.But I granted resoource role to
BHDFORACLE.So BHDFORACLE should have same privileges like
resource role.Why isn't it showing the same privileges.
Regards,
Varun Punj,

[Updated on: Mon, 23 February 2009 17:11]

Report message to a moderator

Re: Privileges [message #388206 is a reply to message #388202]

Mon, 23 February 2009 17:13

varunvir
Messages: 389
Registered: November 2007

Senior Member

Sorry about that.But i dont know how to delete a post if it posted accidently.
Regards,
Varun Punj

Report message to a moderator

Re: Privileges [message #388207 is a reply to message #388195]

Mon, 23 February 2009 17:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Why isn't it showing the same privileges.
Because RESOURCE is not a privilege. It is a ROLE.
ROLE<>privilege. If they were the same, only 1 would exist.

When all else fails, Read The Fine Manual.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

Report message to a moderator

Re: Privileges (merged) [message #388228 is a reply to message #388195]

Mon, 23 February 2009 23:31

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

Senior Member
Account Moderator

Database Concepts
Part I What Is Oracle?
Chapter 20 Database Security
Section Introduction to Database Security

Please read this book 95% of your questions are answered there.

Regards
Michel

Report message to a moderator

Re: Privileges (merged) [message #388288 is a reply to message #388228]

Tue, 24 February 2009 02:30

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Varun,

1/ Connect your user

2/ select * from session_roles;

3/ Select * from session_privs;

From session level you can identifiy your roles and privs; Otherwise AS per Mr Mic; try to read document.

Babu

Report message to a moderator

Previous Topic:	AUDIT in oracle 10g
Next Topic:	What is unsafe with unencrypted data transmission

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 02:09:57 CST 2025