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.

Report message to a moderator

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: 21783
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.

Report message to a moderator

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: 68510
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 30 10:04:29 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.