Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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