| Connect role in dba_role_privs [message #568315] |
Wed, 10 October 2012 12:13  |
 |
dbengineer
Messages: 2
Registered: September 2012
|
Junior Member |
|
|
I'm asked to grant the roles for user HIEL to match user YONC. That's pretty straight forward.
But what I noticed is that user HIEL has a connect role but YONC does not. (Result set is below)
Have searched for information but did not find what I was looking for. I did read something about backward compatibility.
I'm leaning towards that thought since the other user YONC does not have this role.
Database: 11g R1
Please advise. Thanks.
Hope I've placed it in the correct forum. I apologize if it is placed incorrectly.
SQL> select * from dba_role_privs where grantee in ('YONC', 'HIEL') order by grantee;
GRANTEE GRANTED_ROLE ADM DEF
--------------------------- --------------------------- --- ---
YONC WCAIMS_INQUIRY NO YES
YONC ENDUSER NO YES
HIEL WCAIMS_CSR_ADDR NO YES
HIEL WCAIMS_CSR_RIA_ADDR NO YES
HIEL WCAIMS_CSR_TRUST_ADDR NO YES
HIEL CONNECT NO YES
HIEL ENDUSER NO YES[Updated on: Wed, 10 October 2012 12:43] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Connect role in dba_role_privs [message #568319 is a reply to message #568315] |
Wed, 10 October 2012 12:44  |
John Watson
Messages: 3181
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Because I'm feeling nice (and waiting for a 'phone call) I've added the code tags to your post, do you see how much easier to read it is now?
With regard to your question, you are correct, the CONNECT role is officially deprecated. It still exists, but by default it has been crippled. So it won't do any harm, but unless your DBA has reinstated it, it won't do much good either.
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
