Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, sing.

Asked: July 31, 2000 - 6:45 pm UTC

Last updated: December 20, 2005 - 9:44 am UTC

Version: 8.0.6

Viewed 1000+ times

You Asked

Tom,

To create a read-only user is it enough to grant
user x :
object privilege : select on the object in question,
system privilege: connect to database?

Thanks,
Sung

and Tom said...

They do not need connect which might have more then you want. They need only:

o create session

o select on whatever objects you want (or be granted a ROLE
which has the correct select grants)


bear in mind, any privelege granted to PUBLIC will be theirs as well.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Revoking Object Privileges from OWNER itself

AskTom Fan :), December 20, 2005 - 8:29 am UTC

hi tom
how can we revoke the select/insert..etc. privileges on a table from the USER who is also the OWNER of that table?


Tom Kyte
December 20, 2005 - 9:44 am UTC

you cannot, doesn't "make sense"

the correct approach - this "owner" doesn't actually OWN the objects - someone else does.

Or this "owner" doesn't have CREATE SESSION - so they cannot log in.



how to give rights to the different users

MUJAHID, May 06, 2007 - 1:42 pm UTC

TOM I HAVE CREATED THE MENU IN ORACLE 6I AND DEVELOPED SOME FORMS AND I WANT THE GIVE RIGHTS TO THE USER HOW CAN I GIVE THE RIGHT FOR ACCESSING THE MENUS...
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.