Trigger on a sys table

[RDebaquer]

Hello people, my problem is the following, I need to make an insert or update trigger on a table in sys, so I know, can not do, someone would have an idea that can solve the problem?

Thanks
: Wink:

[Tineks]

What is the table that you want to create the trigger ??

[] 's

[RDebaquer]

It's a table I'vê created.
So I have an X list of users who are protected users, can not give Drop or Truncate on any table, and I have another table, with the user name information, owner of the table and permission. I have a bank trigger that identifies these users when a drop or truncate is fired. I need to do another one who does the integrity of this data, I do not know if I explained well ... rs ... xD

[Tineks]

Hello.

This integrity you want to do will serve when a user is deleted you would delete tb the permissions of it ??

[Trevisolli]

Brother,

Would not it be right to treat these permissions (from deleting or not, any table), through role?

tried to take a look at this case?

Whatever doubt, send it there.

[RDebaquer]

It is not user control I need, I just need to ensure that all data in these tables are in capital letters (upper), the PL / SQL is ready, I just need some idea that I can help solve the problem of not being able to create a Trigger on top of a table where the Owner is the SYS. Any idea?

Thanks: LOL:

[Trevisolli]

Brother,

Good, so I understand, in this case, maybe the dba here of the forum has any tips or solution for this case.

I am moving the topic.

Whatever new, send it there.

[gilbertoca]

It is not a user control I need, I just need to ensure that all data in these tables are in capital letters (upper), the PL / SQL is ready, I just need some idea that I can help The problem of not being able to create a trigger on top of a table where the Owner is SYS. Any idea?

Thanks: LOL:

Lamento friend BUT:

Select all

 
oracle@oracleserver:~> sqlplus / as sysdba 
 
SQL*Plus: Release 10.1.0.2.0 - Production on Qui Jan 10 16:58:54 2008 
 
Copyright (c) 1982, 2004, Oracle.  All rights reserved. 
 
 
Connected to: 
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production 
With the Partitioning, OLAP and Data Mining options 
 
SQL> create table gatilho(codigo integer primary key, texto varchar(20)); 
 
Table created. 
 
SQL> create or replace trigger insert_gatilho 
  2  before insert on gatilho 
  3  begin 
  4     raise_application_error( 
  5             num=> -20000, 
  6             msg=> 'não podemos inserir'); 
  7  end; 
  8  / 
create or replace trigger insert_gatilho 
                          * 
ERROR at line 1: 
ORA-04089: cannot create triggers on objects owned by SYS 
 
SQL>            

To complete:

Select all

 
oracle@oracleserver:~> oerr ora 04089 
04089, 00000, "cannot create triggers on objects owned by SYS" 
// *Cause:  An attempt was made to create a trigger on an object owned by SYS. 
// *Action: Do not create triggers on objects owned by SYS. 
oracle@oracleserver:~>          

Gilberto

[RDebaquer]

There is nothing to do ???

I had already seen this error if the bank was small, put a trigger in the bank, but for reasons of optimization, it's not worth it, there's nothing else I can try to do ???

: Cry:


Thanks for the help Galera XD

[Tineks]

These tables exist in sys was you who created? If positive did you choose to create in SYs for security?

You could not create them with another user and restrict access to this new user?

[] 's

[RDebaquer]

By the company's standards, could not ...

I will do some more surveys, if I discover something, notice you.

Thanks guys