Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Granting SELECT permissions to a user based
Dear all,
I have a schema MAIN that holds all my tables. I want to create a user U that should have only SELECT permissions on the complete schema MAIN. How can I grant these permissions to the user without granting SELECT permission on every table of MAIN.* ?
Andreas Received on Mon May 29 2000 - 04:31:01 CDT
![]() |
![]() |