| Batch only Log on to oracle DB [message #124539] |
Mon, 20 June 2005 00:11  |
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
|
Member |
|
|
Hello All,
Is there any way that we can write a trigger or any other way of getting a batch only log on(user) for a user onto a oracle DB. Any suggestions would be greatly appreciated. Thanx in advance.
Vikram
|
|
|
|
|
|
| Re: Batch only Log on to oracle DB [message #124619 is a reply to message #124611] |
Mon, 20 June 2005 09:03  |
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
|
Member |
|
|
Hey Frank,
I have a userid on oracle DB. That user id is used to run a batch job using an universal command in datastage. I dont want anyone to use that particular userid to log on to oracle db but that userid should be able to run a batch job. Would greatly appreciate if you can give me any ideas.
Thanks,
Vikram
|
|
|
|
|
|
| Re: Batch only Log on to oracle DB [message #124621 is a reply to message #124620] |
Mon, 20 June 2005 09:17 |
vikramjogi
Messages: 71
Registered: June 2005
Location: Scranton
|
Member |
|
|
Frank,
I Have a similar trigger where in it blocks the sessions from all the applications, just used '%EXE'. I am sure that a user can rename the name for TOAD as some xyz.exe and run the program.I dont want them to give a chance to do this. Was wondering if anyone can get an idea for my question.
Thanks,
Vikram
|
|
|
|
| Re: Batch only Log on to oracle DB [message #124736 is a reply to message #124621] |
Tue, 21 June 2005 03:18 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
That was just an example. There are many properties in v$session to validate against.
Other examples:
- Run the batch from a dedicated OS user and validate against v$session.osuser.
- Use DBMS_APPLICATION_INFO.SET_MODULE() in your batch to set a unique string and check for it in v$session.module.
- Etc.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
