home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!sun-barr!cs.utexas.edu!usc!sdd.hp.com!uakari.primate.wisc.edu!relay!dcoxmac.nswc.navy.mil!user
- From: dcox@relay.nswc.navy.mil (David Cox)
- Newsgroups: comp.databases.oracle
- Subject: Can one user create table in another's tablespace?
- Message-ID: <dcox-310792114054@dcoxmac.nswc.navy.mil>
- Date: 30 Jul 92 15:50:10 GMT
- Sender: news@relay.nswc.navy.mil
- Followup-To: comp.databases.oracle
- Organization: NSWC
- Lines: 17
-
- Don't ask me how I got into this situation, but I need to allow
- another user to create a table (as part of a weekly procedure)
- in my username. That is, my oracle username/login is, say, david,
- and their's is bob. I need to be able to allow bob to do:
-
- sqlplus bob/hispassword
- >drop table david.acctdata
- >create table david.acctdata (etc...)
- >grant select,insert on david.acctdata to bob
- >grant select on david.acctdata to frank
- >quit
-
- Actually, at some point in the weekly procedure I would like to
- restrict bob to select privilidges on david.acctdata, but this is
- not crucial.
-
- Is there some way I can achieve this without bob having DBA priviledges?
-