| trigger logon on database [message #438648] |
Mon, 11 January 2010 07:00  |
knight
Messages: 111
Registered: January 2009
|
Senior Member |
|
|
user 'app_read' has read only privileges to all tables of user 'applic'
user app_read accesses tables as applic.table_name
I have created foll trigger to avoid prefixing scehma name
create or replace trigger logon_trig
after logon on database
begin
if user in ('APP_READ') then
execute immediate 'alter session set current_schema=APPLIC';
end if;
end;
this is working fine,,,,
i want to know if creating logon triggers has any disadvantages.
or is there any better way to do it.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
