Home » RDBMS Server » Security » how to create user under schema (should access all objects of schema) (10.2.0.3 , window)
how to create user under schema (should access all objects of schema) [message #572001] Wed, 05 December 2012 05:43 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Please guide me to make users under one schema.
1) user should have access of all objects with limited privileges.

How can i make it under schema?

Appreciate your quick reply.

Regards,
Ishika
Re: how to create user under schema (should access all objects of schema) [message #572003 is a reply to message #572001] Wed, 05 December 2012 05:48 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
User owns a schema and can access all his objects (tables, procedures, functions, whatever). Schema = user + his objects. Let's call him USER_A.

You can then create another user (USER_B) and grant him privileges to access objects owned by USER_A. (USER_B will also have his own schema, of course).

It is impossible to create 2 (or more) users in same schema.
Re: how to create user under schema (should access all objects of schema) [message #572009 is a reply to message #572001] Wed, 05 December 2012 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
2 good books for you:
Database Concepts
Database SQL Reference

Read at least the first chapter of the first one.

Regards
Michel
Re: how to create user under schema (should access all objects of schema) [message #577536 is a reply to message #572009] Mon, 18 February 2013 04:41 Go to previous message
TuneMyQuery
Messages: 9
Registered: February 2013
Junior Member

Hi,

A user owns one and only one schema of the same name.

A schema belongs to one and only one user of the same name.

There cannot be any hierarchical dependencies between several schemas/users.

But as Little Foot sais you can grant to user A access to the objects stored in the schema of user B.

Regards,

Emmanuel
Previous Topic: Where to store static SQL (Application or Database) and why?
Next Topic: GRANT Privs TO ROLES
Goto Forum:
  


Current Time: Fri Mar 29 07:15:44 CDT 2024