Re: Granting SELECT permissions to a user based

This iw why there are roles.

On Mon, 29 May 2000, Andreas Jung wrote:

> 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
>
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address jkstill_at_teleport.com - private Received on Mon May 29 2000 - 13:39:23 CDT