June 24th, 2009
Data Control Language, REVOKE Cascading Privileges
Posted by
admin in
R. Data Control Language
When you use the CREATE TABLE statement, you are the table’s owner with SELECT, INSERT, UPDATE, DELETE, and any other privileges allowed by your RDBMS system.You can not use the CREATE VIEW statement without having at least a SELECT privilege on each of the source tables for the view, so you automatically have the SELECT privilege on the view. If you already have the INSERT, UPDATE, or DELETE privileges on the source or base table, then these privileges are automatically given to you on the view by the RDBMS system.
There are other complications that are illustrated in the examples in our course.
Comments Off
