Home » RDBMS Server » Security » DDL
DDL [message #137487] Thu, 15 September 2005 06:36 Go to next message
c_gajen
Messages: 8
Registered: September 2005
Location: Nagpur
Junior Member
hi,
can we prevent user to perform DDL operations for his own table.
if yes then plz..
give me steps for that
thanks!
Gajen

Re: DDL [message #137880 is a reply to message #137487] Sun, 18 September 2005 08:49 Go to previous messageGo to next message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Yes, you can create some schema level database triggers to "block" DDL. There are some examples in the scripts section of this site.

Best regards.

Frank
icon11.gif  Re: DDL [message #138806 is a reply to message #137487] Fri, 23 September 2005 18:48 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Do not give create any, alter any, delete any ... system privliges to the role they are using.
Re: DDL [message #140075 is a reply to message #137487] Fri, 30 September 2005 13:56 Go to previous messageGo to next message
GPradeep
Messages: 1
Registered: September 2005
Location: India
Junior Member
using DML_LOCKS=0 , you can prevent DDLs. But this will affect all the users in the database.

Re: DDL [message #140079 is a reply to message #137487] Fri, 30 September 2005 14:13 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If you are looking only for DDL, this would work.
For DML use a before trigger alongwith.
scott@9i > alter table dept disable table lock;

Table altered.

scott@9i > truncate table dept;
truncate table dept
               *
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for DEPT


scott@9i > alter table dept add (c1 number);
alter table dept add (c1 number)
*
ERROR at line 1:
ORA-00069: cannot acquire lock -- table locks disabled for DEPT


scott@9i > delete from dept;

4 rows deleted.

Previous Topic: resetting passwords for user accounts
Next Topic: Security auditing
Goto Forum:
  


Current Time: Fri Sep 24 04:52:01 CDT 2021