| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Allow user A to create tables in schema B
With the proper user of the CONNECT and RESOURCE role being granted to the =
users and have granted quotas on the tablespace to the users they should =
be able to create /delete tables and procedures that they own in each =
others tablespaces.
ROR m=AA=BF=AAm
>>> hdaiminger_at_vivonet.com 12/06/00 05:29PM >>>
Hi!
How do I allow user A to create/drop tables and procedures in schema B without granting the CREATE ANY TABLE/PROCEDURE privilege to user A?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Helmut Daiminger
INET: hdaiminger_at_vivonet.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 07 2000 - 08:22:45 CST
 |
 |