OraFAQ Forum: Security » how to create user under schema (should access all objects of schema)

Home » RDBMS Server » Security » how to create user under schema (should access all objects of schema) (10.2.0.3 , window)

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

how to create user under schema (should access all objects of schema) [message #572001]

Wed, 05 December 2012 05:43

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

Report message to a moderator

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

Littlefoot
Messages: 21826
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.

Report message to a moderator

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 03 19:53:20 CST 2026