 |
|
|
|
|
|
|
|
|
|
|
 |
 |
|
||||||||
 |
    |
|
||||||||
 |
|
|
||||||||
|
|
|||||||||
|
Test
user authentication against the database Now we will test our new Enterprise Role. Our test scenario will be to login to the database as pneedham who has been granted access to our new Enterprise Role. # sqlplus pneedham/welcome1 Now lets examine how pneedham is connecting to the database. SQL> select user from dual; Now lets examine the user context and user name for this connected user. SQL> select sys_context ('userenv' ,'external_name') from dual;
Now lets login as a user who has not been granted this role. # sqlplus nlewis/welcome1 Since nlewis has not been granted the new role she cannot connect to the database.
|
 |
|
||||||||
 |
 |
 |
 |
 |
|
|||||
 |
|
|||||||||
