Oracle connect and RESOURCE role permissions, oracleconnect
Recently, I was dealing with database user permissions. Previously, I thought that after the RESOURCE permission is granted to the user, the user's general permissions will be available. When the user is found to have a RESOURCE role, I didn't have the permission to create a view, so I found that this part is completely unknown. So I sorted out the related content of the CONNECT role and the RESOURCE role here.
Generally, after a new database user is created, the user is habitually authorized with the "CONNECT" and "RESOURCE" roles:
GRANT connect, resource TO user;
But what permissions do users with these two roles have? You can use the following statement to View Details:
SELECT * FROM dba_sys_privs WHERE grantee IN ('RESOURCE', 'CONNECT') ORDER BY 1;
The query results show that:
Grant create view to user;
So what permissions does a user have?
Method 1: PLSQL Developer Tool
In PLSQL Developer, you can easily view various types of permissions (including object permissions, role permissions, and system permissions), such:
SELECT * FROM dba_tab_privs a WHERE a. grantee = 'username ';
Query role permissions:
SELECT * FROM dba_role_privs a WHERE a. GRANTEE = 'username ';
Query System permissions:
SELECT * FROM dba_sys_privs a WHERE a. GRANTEE = 'username ';
Oracle 10g permission Assignment Problems for the role CONNECT, RESOURCE permissions I view, I grant a user these two roles
The RESOURCE permission includes the ability to create and Delete tables and dml objects under the user!
Unlimited tablespace is an UNLIMITED permission that users can use the default tablespace!
This is the CONNECT that I have granted to getl. view it after the RESOURCE permission:
Sys @ TB> select privilege from dba_sys_privs where grantee = upper ('& U ');
Enter value for u: getl
Old 1: select privilege from dba_sys_privs where grantee = upper ('& U ')
New 1: select privilege from dba_sys_privs where grantee = upper ('getl ')
PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE
CREATE ANY VIEW
CREATE ANY TABLE
DEBUG ANY PROCEDURE
SELECT ANY TABLE
DEBUG CONNECT SESSION
CREATE SESSION
7 rows selected.
What are the permissions of oracle roles? Both the CONNECT role and the RESOURCE role have the create sequence permission.
The name is different.