| Drop table [message #57933] |
Mon, 21 July 2003 02:17  |
Raj Mathur
Messages: 11
Registered: April 2002
|
Junior Member |
|
|
if there is any way to monitor or restricting a user to drop his tables as a dba's point of view.
can we put any restriction or monitor whether a user deleting his own table .Can we create a trigger
for that
|
|
|
|
| Re: Drop table [message #57934 is a reply to message #57933] |
Mon, 21 July 2003 03:46  |
Martin Lehmann
Messages: 3
Registered: June 2003
|
Junior Member |
|
|
Hi,
You can use a database trigger.
CREATE TRIGGER audit_db_object BEFORE DROP
ON <schema>
begin
.....
end;
/
SQL Reference Manual 9i
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
