Home » SQL & PL/SQL » SQL & PL/SQL » Logon trigger
Logon trigger [message #243912] Mon, 11 June 2007 00:22 Go to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi,
We have the setup of siebel crm with oracle as backend.The users login to siebel application using siebel tools(sadmin).They can even login through sqlplus,toad etc..We are planning to restrict such users by the logon triggers.I have written some tables and procedures,triggers for the same,but i am still not satisfied with the result.Can anyone please suggest a logic to do the same.

Thanks
Re: Logon trigger [message #243924 is a reply to message #243912] Mon, 11 June 2007 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you tried and why this does not satisfy you.
Please post your Oracle version (4 decimals).
Please read and apply How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS.
Search on this forum, logon trigger have been assigned many times.

Regards
Michel

[Updated on: Mon, 11 June 2007 01:11]

Report message to a moderator

Re: Logon trigger [message #243939 is a reply to message #243912] Mon, 11 June 2007 01:28 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
Hi Michel,
Yes, the logon trigger topic has been discussed,but I want to explore beyond the given solution.I am enclosing the solution by me,kindly have a look and suggest something to enhance it.Sorry about formatting and all,as i rarely raise a issue Razz .The db version is 9.2.0.8

[Updated on: Mon, 11 June 2007 01:53]

Report message to a moderator

Re: Logon trigger [message #243945 is a reply to message #243939] Mon, 11 June 2007 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Sorry about formatting

Read the link I posted and edit your post to format it.
This is a prerequirement for any help from me.
Quote:
I am enclosing the solution by me,kindly have a look and suggest something to enhance it.

Does it or not satisfy your requirements? If not, why?
Please answer the question I post, this is a prerequirement for any help from me.

Regards
Michel
Re: Logon trigger [message #243960 is a reply to message #243912] Mon, 11 June 2007 02:10 Go to previous messageGo to next message
pooja_g
Messages: 56
Registered: December 2005
Location: India
Member
The application level superuser,has access to all backend tables
.

We want to enforce restriction on such access through sqlplus,toad ..etc.The validations i have given are sufficient.If anyone else has implimented such a option,I just wanted to compare the logic behind their implimentation.
Re: Logon trigger [message #243965 is a reply to message #243960] Mon, 11 June 2007 02:15 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you erased your code I think you want to close the topic.

This is done.
./fa/448/0/

Regards
Michel
Previous Topic: How to convert column data into row
Next Topic: Case and Decode
Goto Forum:
  


Current Time: Sat Dec 03 01:05:18 CST 2016

Total time taken to generate the page: 0.07337 seconds