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: 4596
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: 10708
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 May 02 15:51:06 CDT 2025