July 10th, 2009
Data Control Language, TO PUBLIC
Posted by
admin in
R. Data Control Language
Format: GRANT {SELECT | INSERT | UPDATE | DELETE} [column_names]
ON {table_name | view_name}
TO {user_id | PUBLIC} [WITH GRANT OPTIONS];
When you GRANT privileges TO PUBLIC, it means that you are giving privileges on this table to all current and future users who can access the database or schema. Obviously you should only use this privilege with extreme care and some installations never use this option.
Comments Off
