OraFAQ Forum: Security » need to create a user with access to only two tables

Home » RDBMS Server » Security » need to create a user with access to only two tables (8.1.7,win 2003 server)

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

need to create a user with access to only two tables [message #461915]

Tue, 22 June 2010 02:11

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Hi friends,

I have to create a user who has access to only two tables in a tablespace. Please tell me what priviliges does it require and i need only read access on this two tables

Report message to a moderator

Re: need to create a user with access to only two tables [message #461928 is a reply to message #461915]

Tue, 22 June 2010 02:57

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Got the answer. Thanks

Report message to a moderator

Re: need to create a user with access to only two tables [message #461933 is a reply to message #461928]

Tue, 22 June 2010 03:08

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So post it for future readers.

Regards
Michel

Report message to a moderator

Re: need to create a user with access to only two tables [message #461947 is a reply to message #461933]

Tue, 22 June 2010 03:47

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

GRANT SELECT ON <TABLESPACE_NAME>.<TABLE_NAME> TO <USER>;

Report message to a moderator

Re: need to create a user with access to only two tables [message #461956 is a reply to message #461947]

Tue, 22 June 2010 04:29

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is not TABLESPACE_NAME but SCHEMA_NAME (owner name).

Regards
Michel

Report message to a moderator

Re: need to create a user with access to only two tables [message #462316 is a reply to message #461956]

Wed, 23 June 2010 08:39

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Thanks Michel for the correction. Smile

Report message to a moderator

Previous Topic:	Views, DBLinks and Priv "Workarounds"
Next Topic:	protect from unauthorise user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 16:46:10 CDT 2023