Setting Authority Level

How To

There are three levels of authority: CONNECT, RESOURCE, and DBA. Any users that are created but have not yet been granted RESOURCE or DBA authority will have CONNECT authority by default. A user with CONNECT authority may create temporary tables in a database, or perform queries on any data to which they have explicitly been granted permission. A user that is created and granted RESOURCE authority can create, alter, and drop tables, domains, and indexes. As the owner of any objects they create, users with RESOURCE authority may grant and revoke object privileges to other users and create synonyms and views for any objects they own. DBA authority has all same capabilities as RESOURCE authority, but may additionally create tablespaces and files. Users with DBA authority can also grant or revoke object privileges for schema objects owned by other users (except for system schema objects).


Related topic:

Changing Security Level