Home » RDBMS Server » Security » HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS (ORACLE 10G, WIN XP)
HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS [message #352027] Sun, 05 October 2008 06:21 Go to next message
shajat
Messages: 25
Registered: October 2008
Location: INDIA
Junior Member
Hi,
How to restrict the user from disabling trigger status. If anybody wants to alter the trigger status to disabled, is it possible to restrict the user from altering the trigger status or is it possible to know who has disable the trigger.

Thanks in advance.
Re: HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS [message #352042 is a reply to message #352027] Sun, 05 October 2008 09:05 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Simply, noone should have access to production database in a way that he/she could modify code or database objects anytime he/she wants it. Users obviously don't need that. Developers must not have that. So - you'll have to change something in order to put your database under control.
Re: HOW TO RESTRICT THE USER FROM DISABLING TRIGEER STATUS [message #352043 is a reply to message #352027] Sun, 05 October 2008 09:06 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't put your topic title in UPPER case
2/ Don't use the owner of objects for standard user
3/ Don't give standard users powerful privileges

Regards
Michel
Previous Topic: Login Problem with Database
Next Topic: Find User Usage Log
Goto Forum:
  


Current Time: Thu Mar 28 13:45:16 CDT 2024