Re: 2 users: 1 for tables,views.. 1 for functions,procedures...

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 Wed May 07 2003 - 06:38:08 CDT