Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Grant Update Command

Grant Update Command

From: allen lucas <alucus_at_concentric.net>
Date: 1997/11/26
Message-ID: <347C3A56.6C59@concentric.net>#1/1

I must be missing something simple. We are running ORA WGS 7.2.2.4.9 on NT 3.51 and supporting PeopleSoft.

PeopleSoft creates a table PS.PSDBOWNER. I am defined with the DBA role. PS is a peoplesoft administration schema, and sysadm is a peoplesoft user/schema. I try to grant update on ps.psdbowner to sysadm and receive a oracle error stating insufficient privleges. Is there a way for the schema owner, PS, to lock the DBA from granting rights on a table they own? How can they do this and can this be overridden by the DBA? Thanks..

-- 

===================================================================
\\||// Got a little change in my pocket, / \ going jingle angle angle. []--[] @ /\ @ {----} ^^ alucus_at_concentric.net
===================================================================
Received on Wed Nov 26 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US