Home » RDBMS Server » Security » need to create a user with access to only two tables (8.1.7,win 2003 server)
need to create a user with access to only two tables [message #461915] Tue, 22 June 2010 02:11 Go to next message
ultgnp
Messages: 105
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
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 Go to previous messageGo to next message
ultgnp
Messages: 105
Registered: May 2010
Location: Germany
Senior Member
Got the answer. Thanks
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66928
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So post it for future readers.

Regards
Michel
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 Go to previous messageGo to next message
ultgnp
Messages: 105
Registered: May 2010
Location: Germany
Senior Member


GRANT SELECT ON <TABLESPACE_NAME>.<TABLE_NAME> TO <USER>;
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 Go to previous messageGo to next message
Michel Cadot
Messages: 66928
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not TABLESPACE_NAME but SCHEMA_NAME (owner name).

Regards
Michel
icon14.gif  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 Go to previous message
ultgnp
Messages: 105
Registered: May 2010
Location: Germany
Senior Member
Thanks Michel for the correction. Smile
Previous Topic: Views, DBLinks and Priv "Workarounds"
Next Topic: protect from unauthorise user
Goto Forum:
  


Current Time: Sun Mar 29 02:02:29 CDT 2020