Home » RDBMS Server » Security » granted the create view priv exclusively
granted the create view priv exclusively [message #7854] Sun, 13 July 2003 02:02 Go to next message
Abu Arbab
Messages: 13
Registered: June 2003
Junior Member
Hi
How to grant the create view priv exclusively to the users
Re: granted the create view priv exclusively [message #7858 is a reply to message #7854] Sun, 13 July 2003 08:12 Go to previous messageGo to next message
lajna
Messages: 8
Registered: June 2003
Junior Member
i hope this helps

grant create view to username;
Re: granted the create view priv exclusively [message #7864 is a reply to message #7858] Mon, 14 July 2003 02:12 Go to previous messageGo to next message
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;
/
Re: granted the create view priv exclusively [message #7876 is a reply to message #7864] Mon, 14 July 2003 13:48 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The owner of this procedure needs direct grants (not privileges through a role) to create/drop views.

Re: granted the create view priv exclusively [message #7885 is a reply to message #7864] Tue, 15 July 2003 05:42 Go to previous message
lajna
Messages: 8
Registered: June 2003
Junior Member
In which user are u running the procedure and to which user are u granting select access --- this is not clear
Previous Topic: sysdba/resource privs
Next Topic: oracle security
Goto Forum:
  


Current Time: Mon Nov 23 16:48:48 CST 2020