-
Modifying views
If I want to modify views in another user's schema, I should have CREATE ANY VIEW privilege. Am I right? Is there anything called ALTER VIEW? My database is 9i. I think in addition to the system privilege, I should have appropriate access to the underlying objects in the view. Is there a way to limit my ability to modify to only a few views? I think with CREATE ANY VIEW privilege, I can modify view in any user's schema. I think there is no way to limit my ability to modify to a fiew views only with that system privilege. Please let me know if I am wrong. Thanks.
-
well the problem is that there is not ALTER VIEW or ALTER ANY VIEW like pribileges in oracle and u need to user CREATE OR REPLACE command to make any modifications in a view. This is also correct that u need to have CREATE ANY VIEW to create views in some ones schema....in ur case...keep one thing in ur mind that any privilege with ANY key word is given to a very very trusted user not every one...so if user is a trustworthy user than give him this right with appropriate selection or insertion or updation on deletion rights on the table in each schema to this trustworthy user so that ithe could create views on onle the tables u want him to seee
Regards
Salman Ahmed Qureshi
Lahore, Pakistan
-
These advanced permission problems are often best solved with a stored procedure ... you can define a procedure to accept a view name, a schema name, and a query string, and validate that the view name is one that the user is allowed to create or replace or that it is to be in a permitted schema ... then you grant execute on the procedure to single users of course.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|