Hallo Antoine,
excuse for the dealay in answering.
The links you gave me are broken, do you have a copy of the documents?
Thanks,
Stefano
"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message news:<3eb8f021$0$14840$79c14f64_at_nan-newsreader-02.noos.net>...
> Hi from Paris
>
> Oracle RDBMS allows you to precisely define user rights and privilege, both
> for DDL and DML operations.
>
> In your case, you could:
>
> create the two users, and grant them the "create session privilege"
>
> Then, the first one will be allowed to create schema objects, and will a
> quota privilege on the tablespace.
> The other user will only have privileges to create package, etc...
>
> I recommand you to check to two following links:
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htm#17434
>
> and
>
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_912a.htm#2062195
>
> Cdlt
>
>
>
> "Stefano Zanmarchi" <szanmarchi_at_libero.it> a écrit dans le message de
> news:7d5ccb96.0305070154.201d2348_at_posting.google.com...
> > Hi,
> > can anyone help me with this issue?
> > I have created 2 users: tom_tab and tom_prc.
> > - tom_tab's schema only contains tables, views, indexes, and sequences.
> > - tom_prc's schema only contains procedures, functions, packages
> > Both users share the same tablespace.
> > Now, how can I prevent user tom_tab from creating procedures,
> functions,...
> > and user tom_prc from creating tables, views,... ?
> > Thank you very much,
> > Stefano
Received on Fri May 16 2003 - 04:54:46 CDT
