create user with access to only one view

[jarthi]

Hi:
I would like to create a user and give access to only one view in the entire database.
Is it possible to do it? If so how?

Thanks,
Arthi

 

[THoey]

Sounds like you could do this simply with a couple of commands:

CREATE USER Scott IDENTIFIED BY Tiger;

GRANT SELECT ON Schema.ViewName TO Scott;

This is a pretty basic administrative task. If you are having trouble with it, I am going to politely suggest some DBA training or a good Oracle DBA book. It gets a bit more difficult after this... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[Turkbear]

In additon to THoey's reply, be aware that any PUBLIC synonyms you may have created ( or were created at Database create time) will be accessable to ANY user - this includes many system and sys views that access
the data dictionary, etc...

So , strictly, any user can see many views..

 

[karluk]

Terry's suggestion is the right way to go, but you will also have to grant connect to the id in order to allow it to log in.

grant connect to scott;