Home » SQL & PL/SQL » SQL & PL/SQL » TRIGGER FOR CREATE VIEW (ORACLE 10g)
TRIGGER FOR CREATE VIEW [message #302351] Mon, 25 February 2008 05:32 Go to next message
benedikts
Messages: 1
Registered: February 2008
Junior Member
Hello Everybody,

I want to create a trigger that always when a User X create a view
with the name y grants select on the view y for the role z.
It should look something like:
CREATE TRIGGER user.trigger1 AFTER CREATE VIEW ON user
WHEN (new_created_view's name is y)
BEGIN
GRANT SELECT ON user.y TO z;
END trigger1;

Thanks for your help
Benedikt
Re: TRIGGER FOR CREATE VIEW [message #302354 is a reply to message #302351] Mon, 25 February 2008 05:36 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Fundamentals,
Chapter 9 Coding Triggers

PL/SQL User's Guide and Reference,
Chapter 7 Performing SQL Operations with Native Dynamic SQL

Regards
Michel
Previous Topic: Substitution variable into a procedure (merged)
Next Topic: Changes in Password Verification Function (please help urgently)
Goto Forum:
  


Current Time: Sat Dec 10 22:50:01 CST 2016

Total time taken to generate the page: 0.11129 seconds