Re: A Users Security problem...

How can I grant 'SELECT'-rights on each present/future table in e1's schema ?
I cannot set 'SELECT'-rights for each newly created table...

                                                   
 Luca Minudel                    software designer
 Italy                             Conegliano (TV)
 voice & fax                     +39 (0)438 412280
 e-mail                      luca.minudel_at_nline.it
 WWW                       (italian language used)

Matthias Gresz <GreMa_at_t-online.de> scritto nell'articolo <6ft8r0$lcc$1_at_news02.btx.dtag.de>...
> On 31 Mar 1998 17:57:57 GMT, "Luca Minudel" <luca.minudel_at_nline.it>
 wrote:
> Hi Luca,
>
> let's imagine that user Ezio has these accounts:
>
> e1 granted role SOFWARE USER
> and
> e2 granted role BASIC USER
>
> to let e2 access e1's schema you must grant e1 'SELECT'-rights on e1's
 schema.
>
> >Hi all,
> > I'm setting users security in a Oracle Db, here comes my problems.
> >I've put all Tables in a Db schema "MAIN" and I've defined two Roles
 

> > - "SOFWARE USER" with Select/Update/Insert/Delete priviliges
> > for each table in "MAIN" schema.
> > This role can only create/drop in default user tablespace.
> > - "BASIC USER" with only Select privilege for each table in "MAIN".
> >
> >Each user will have 2 account, one with "SOFWARE USER" role and one
 with > >"BASIC USER".
> >The first account with "SOFWARE USER" role will be used only by an
 > >application I wrote (the password is hardcoded in the application).
> >The second user account will be used by user from Oracle
 SQL-WorkSheet > >or similar.
> >
> >My application create temporary tables in the first user
 account/schema > >(the user account my application connects to).
> >I need an EASY way to let users (connected with their second account
 > >from SQL-WorkSheet or similar) to select from these temporary tables.
> >
> >I don't want to rewrite my application for granting privileges and
 > >creating synonyms for temporary tables to the second account.
> >
>
> Matthias Gresz :-)
>
> GreMa_at_T-online.de
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST