Re: How can I make Scott go public?

In article <6oceri$h1u$1_at_news.iinet.net.au>,   "Denys Williams" <sysadmin_at_bunbury.training.wa.gov.au> wrote:
> Sorry people,
>
> I have little or no idea about oracle databases but I need to achieve the
> following on a server that I am looking after.
>
> I need to grant all rights (alter delete index insert preferences select
> update) for all tables in schema SCOTT to a role (called DEMO) - is there an
> SQL command I can use (and if so what is it?) or must I systematically
> allocate each right from each table to the role?
>
> Do I need to be logged on as scott or can I perform this operation as a
> DBA?
>
> What privilidges would the DBA account be using to perform this operation?
>
> How do I reverse the changes at a later date?
>
> Thanks a million in advance to any kind souls that can render assistance on
> this one...
>
> Denys Williams
> Computer Systems & Network Administrator & Oracle Rookie
> SWRC of TAFE
>

You need to be scott or someone else that scott's given privileges to (including the "with grant option" clause).

i do believe you need to grant access to each table (once for table a, once for table b, ...)

you can grant all privileges at the same time using the ALL clause.

Like this:

sql>grant all on emp to my_role;

Revoke them the other way:

sql>revoke all on emp from my_role;

regards.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 13 1998 - 10:15:27 CDT