Books for you

Security Privileges
Four basic types of database operations can be limited by security privileges in an
Oracle database:
??? SELECT to perform queries
??? INSERT to put rows into tables or views
??? UPDATE to update rows in tables or views
??? DELETE to remove rows from tables, table partitions, or views
In addition to these data-specific privileges, several other privileges apply to the
objects within a database schema:
??? CREATE to create a table in a schema
??? DROP to remove a table in a schema
??? ALTER to alter tables or views
142 | Chapter 6: Oracle Security, Auditing, and Compliance
All of these privileges can be handled with two simple SQL commands. The GRANT
command gives a particular privilege to a user or role, while the REVOKE command
takes away a specific privilege. Youcan use GRANT and REVOKE to modify the
privileges for an individual or a role. You can also grant the ability to regrant privileges
to others. Youcan use either of these commands with the keyword PUBLIC to
issue or revoke a privilege for all database users.


Pages:
296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320