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

Home -> Community -> Usenet -> c.d.o.server -> Re: Roles & Privileges

Re: Roles & Privileges

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 May 2001 21:23:05 +0200
Message-ID: <tglf0r1g8s0p4d@beta-news.demon.nl>

"Mark Wallace" <mwallace*NOSPAM*@*NOSPAM*carr-sheppards.co.uk> wrote in message news:W4xO6.305$3S3.6269_at_news.lhr.globix.net...
> I am at the start of setting up a new system. What I want to do is have
 all
> the application tables, indexes, packages etc, etc... in a central
> application schema. For example called 'Applic'
> This schema has its own tablespace (ApplicData_ts) and temporary
 tablespace
> (ApplicTemp_ts).
>
> I have now created a couple of users (usera, userb etc...) also using the
> same tablespaces.
> The users must have no rights to create any of there own database objects.
> But must have rights to select, update, execute etc, etc... from the
> applications tables.
>
> How do setup a user to automatically have access to all 'Applic' schemas
> object without having to specify each object individualy as in,
> grant select on tablea to usera
> grant select on tableb to usera
> grant update on tablea to usera
> etc .etc .etc..... for all DB Objects that the application uses.
>
> Do I grant the privileges to a role and then the role to the users. But
> still have to grant each privilege individualy to the role?
> Is there a better way of doing this.
>
> Any suggestions or comments appreciated.
>
> Thanks
> Mark
>
>

Granting to a role is an one-time operation. Hopefully that is not too much work for you

Regards,

Sybrand Bakker, Oracle DBA Received on Tue May 22 2001 - 14:23:05 CDT

Original text of this message

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