| Create various Users on a schema [message #483211] |
Fri, 19 November 2010 04:05  |
Bernardo2789
Messages: 1
Registered: November 2010
|
Junior Member |
|
|
|
hi guys i do a schema in oracle ... anm my question is if I can create 2 o more users for access to a schema..for example i have schema Project and i need that one administrator and 2 more users with others permision...
|
|
|
|
|
|
| Re: Create various Users on a schema [message #483216 is a reply to message #483213] |
Fri, 19 November 2010 04:12  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Schema = User + its objects (tables, views, procedures, etc.)
Obviously, schema is owned by a single user. You can, though, create as many users as you want and let them access objects owned by someone else. In order to do that, owner should grant certain privileges (such as SELECT / UPDATE / EXECUTE etc.). Other users can then either access those objects directly (by specifying owner name, such as SELECT * FROM owner_name.table_name) or by creating synonyms in their own schema (which would then act as if they were his/her "own" objects).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
