Home » SQL & PL/SQL » SQL & PL/SQL » Table Access
Table Access [message #21189] Wed, 17 July 2002 11:31 Go to next message
Arpit
Messages: 99
Registered: March 2001
Member
Hello

How can I grant read access to a few tables to a oracle user.

I've a oracle user "a" which our users use to retreive data through MS Query.

How can I grant access to some tables which are not listed under user "a" from the system user.

Report message to a moderator

Re: Table Access [message #21191 is a reply to message #21189] Wed, 17 July 2002 11:55 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
As the owner of those tables:

sql>grant select on table_1 to a;
sql>grant select on table_2 to a;

Report message to a moderator

Previous Topic: Median
Next Topic: How do I completely remove a tablespace?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:08:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.