Members   Search   Help    Register    Login   Home
Home » RDBMS Server » Security » PRIVILEGES
PRIVILEGES [message #393482] Mon, 23 March 2009 01:00 Go to next message
charuamit
Messages: 77
Registered: January 2009
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 Go to previous messageGo to next message
BlackSwan
Messages: 3227
Registered: January 2009
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 Go to previous messageGo to next message
JRowbottom
Messages: 5254
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 Go to previous message
Mohammad Taj
Messages: 2410
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 13:05:58 CST 2009

Total time taken to generate the page: 0.18789 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.