Home » RDBMS Server » Security » Create various Users on a schema
Create various Users on a schema [message #483211] Fri, 19 November 2010 04:05 Go to next message
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 #483213 is a reply to message #483211] Fri, 19 November 2010 04:09 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Its not clear for me .
I guess you are talking about privilages isn`t it ?

sriram
Re: Create various Users on a schema [message #483216 is a reply to message #483213] Fri, 19 November 2010 04:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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).
Re: Create various Users on a schema [message #483245 is a reply to message #483216] Fri, 19 November 2010 08:02 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition to LittleFoot answer, you should read Database Concepts, at least the first chapter ("Introduction to the Oracle Database") as you lack the basic knowledge on Oracle.

Regards
Michel

[Updated on: Fri, 19 November 2010 08:02]

Report message to a moderator

Previous Topic: How to Enhance Security of Windows and Recover Lost/Forgotten Password
Next Topic: Database Hardening
Goto Forum:
  


Current Time: Thu Mar 28 15:36:40 CDT 2024