|
-
it forgives, my English is very poor. I translating use (www.altavista.com) to pass of the Portuguese for English but is accurately this that wanted to say verified and only the DBAs none possesss DBA. Grant another one possesss permissions of restricted access.
It follows in annex the list of permissions of this base.
SQL> select granted_role, count(*) from dba_role_privs group by granted_role;
GRANTED_ROLE COUNT(*)
------------------------------ ----------
AQ_ADMINISTRATOR_ROLE 2
AQ_USER_ROLE 1
CONNECT 68
DBA 6
DELETE_CATALOG_ROLE 2
EXECUTE_CATALOG_ROLE 4
EXP_FULL_DATABASE 3
HS_ADMIN_ROLE 3
IMP_FULL_DATABASE 2
JAVADEBUGPRIV 1
JAVAIDPRIV 1
JAVASYSPRIV 1
JAVAUSERPRIV 3
JAVA_ADMIN 2
JAVA_DEPLOY 2
METRO_SELECT_TOTAL 19
OEM_MONITOR 1
RECOVERY_CATALOG_OWNER 1
RESOURCE 8
ROLEFOLHASOFT 54
ROLERELATORIO 54
SELECT_CATALOG_ROLE 7
SNMPAGENT 2
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|