OS login [message #260020] |
Fri, 17 August 2007 02:54 |
jesuisantony
Messages: 166 Registered: July 2006 Location: Chennai
|
Senior Member |
|
|
A database was created recently. That should be accessed only by 3 members from the project team. And all the 3 members will use the same Oracle user ID to login to the database. But the project team wants to make sure that only those 3 users should be able to login into that database. Is there anyway that I can restrict the OS users and allow the 3 OS users alonne to use the Oracle login ID.
|
|
|
|
|
|
Re: OS login [message #260145 is a reply to message #260044] |
Fri, 17 August 2007 10:47 |
transfer
Messages: 53 Registered: August 2007 Location: transfer
|
Member |
|
|
If you have code that does not reference the schema explicitly, you can use an "after logon" trigger to change the current schema :create or replace trigger use_appuser_schema
after logon on realuser.schema
begin
execute immediate 'alter session set current_schema = appuser';
end;
/ Once "realuser" logs on, if he executes
the code will reference appuser.mytable. However,select * from user_tables; will still list the tables of which "realuser" is the owner!
|
|
|