OraFAQ Forum: Security » granted the create view priv exclusively

Home » RDBMS Server » Security » granted the create view priv exclusively

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

granted the create view priv exclusively [message #7854]

Sun, 13 July 2003 02:02

Abu Arbab
Messages: 13
Registered: June 2003

Junior Member

Hi
How to grant the create view priv exclusively to the users

Report message to a moderator

Re: granted the create view priv exclusively [message #7858 is a reply to message #7854]

Sun, 13 July 2003 08:12

lajna
Messages: 8
Registered: June 2003

Junior Member

i hope this helps

grant create view to username;

Report message to a moderator

Re: granted the create view priv exclusively [message #7864 is a reply to message #7858]

Mon, 14 July 2003 02:12

Abu Arbab
Messages: 13
Registered: June 2003

Junior Member

I can create view but the problem is that
when i run the following procedure it is giving an error insufficient privileges

CREATE OR REPLACE procedure qap_run_MT_View
as
BEGIN
EXECUTE IMMEDIATE 'drop materialized view QAP_MS_VIEW';
EXECUTE IMMEDIATE 'create materialized view QAP_MS_VIEW as select * from QAP_document ';
EXECUTE IMMEDIATE' grant select on QAP_MS_VIEW to qry_lims';
END;
/

Report message to a moderator