Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
2 users: 1 for tables,views.. 1 for functions,procedures...
2 users: 1 for tables,views.. 1 for functions,procedures...
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 - 04:54:15 CDT
Original text of this message