OraFAQ Forum: Security

Home » RDBMS Server » Security » PRIVILEGES

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

PRIVILEGES [message #393482]

Mon, 23 March 2009 01:00

charuamit
Messages: 121
Registered: January 2009

Senior Member

Hi Friends

I need some help :
We use 5 different schema....in all the schemas we want to create three users - Admin , Others and User.....3 roles for each and different grants .....

But i want to use the same name for users,roles....but grants on different table names in different schemas....

How do we achieve this ....because if you use the same names you get and error of name conflict.

Thanks
Charu

Report message to a moderator

Re: PRIVILEGES [message #393495 is a reply to message #393482]

Mon, 23 March 2009 01:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

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.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

Report message to a moderator

Re: PRIVILEGES [message #400939 is a reply to message #393482]

Thu, 30 April 2009 07:52

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I think you're confused about the terminology used in Oracle.

A Schema is synonymous with a User

Report message to a moderator

Re: PRIVILEGES [message #405170 is a reply to message #393482]

Tue, 26 May 2009 13:18

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

We use 5 different schema....in all the schemas we want to create three users - Admin , Others and User.....

as said above...user is a schema & schema is a user
you can create three user/schema in a database.

Report message to a moderator

Previous Topic:	Role with execute package and drop table
Next Topic:	database password changes (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 19 21:32:28 CDT 2021