Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Granting SELECT permissions to a user based

Granting SELECT permissions to a user based

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Mon, 29 May 2000 11:31:01 +0200
Message-Id: <10512.107006@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US