You must grant with grant option to give permission for granting an object. I mean as sys you should:
grant select on v_$instance to gcss with grant option And the other grant. Regards. --- "Ranganath, Krishnaswamy" <[EMAIL PROTECTED]> wrote: > Hi DBA Gurus, > > I am getting the below error while trying to grant > select privileges > on a view owned by a user by name GCSS to another > user by name etldev: > > ORA-01720: grant option does not exist for > 'SYS.V_$INSTANCE' > > I even granted select on sys.v_$instance to etldev. > Still the > problem persists. What could be the problem? > Anybody can throw some light > on this? > > Thanks and Regards, > > KR > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Ranganath, Krishnaswamy > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
