Configuring user authorization

Configuring user authorization While authentication determines whether someone is a legal database user, authorization determines what operations can be performed by a user's identity. databasesauthorization authorizationcoarse-grained authorizationfine-grained

Once you have set up authentication, you can configure authorization.

offers two kinds of authorization:

Coarse-grained authorization, in which the Database Owner divides an application's users into two groups. One group has full authority to read and write all data. The other group merely has permission to read data.
Fine-grained authorization, in which the Database Owner and individual users issue SQL GRANT/REVOKE statements to declare who can read or write specific pieces of data and who can exercise specific application functions.