Why cannot I create triggers on objects owned by SYS?

by

You should not be creating any objects in the SYS schema. That user is part of the Oracle database management system, and changing its schema is likely to break your database. Certainly it could invalidate your Oracle Support contract (if you have one). From the documentation:

“The administrative account SYS is automatically created when a
database is created. This account can perform all database
administrative functions. The SYS schema stores the base tables and
views for the data dictionary. These base tables and views are
critical for the operation of Oracle Database. Tables in the SYS
schema are manipulated only by the database and must never be modified
by any user.”

Oh, in case you’re wondering, the same applies to SYSTEM too.

Triggers are particularly prone to abuse and are a major source of scaling problems. That’s why Oracle forbids us to build triggers in SYS, because doing so might corrupt or at least impact the performance of the data dictionary.

Of course that’s not what’s happening here. You have built your own tables in SYS. Well drop them. Now. Use SYS to create your own user, GHAZAL or whatever name suits, and grant it the required privileges: CREATE SESSION, CREATE TABLE, CREATE TRIGGER, and so forth. Then connect as that new user to create your tables and other schema objects.

More Related Contents:

  1. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  2. Create Pivot view in SQL from a SQL table
  3. Functions vs procedures in Oracle
  4. passing in table name as plsql parameter
  5. How to use parameters in a ‘where value in…’ clause?
  6. No more data to read from socket
  7. What is the replacement of cursor foreach in oracle pl/sql?
  8. Printing the value of a variable in SQL Developer
  9. PL/SQL, how to escape single quote in a string?
  10. Passing an array of data as an input parameter to an Oracle procedure
  11. Convert comma separated string to array in PL/SQL
  12. UTL_FILE.FOPEN() procedure not accepting path for directory?
  13. Oracle stored procedure with parameters for IN clause
  14. NLS_NUMERIC_CHARACTERS setting for decimal
  15. Split function in oracle to comma separated values with automatic sequence
  16. check if “it’s a number” function in Oracle
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  19. SQL*Plus how to accept text variable from prompt?
  20. if (select count(column) from table) > 0 then
  21. Can We use threading in PL/SQL?
  22. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  23. How can I describe a table in Oracle without using the DESCRIBE command?
  24. How to insert a column in a specific position in oracle without dropping and recreating the table?
  25. Reading clob line by line with pl\sql
  26. BEGIN – END block atomic transactions in PL/SQL
  27. Subtracting Dates in Oracle – Number or Interval Datatype?
  28. How do I get column datatype in Oracle with PL-SQL with low privileges?
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. Escaping single quote in PLSQL

Leave a Comment