Insufficient privilege: 7 OSIBKA: to be the owner of XXX



  • I'm trying to remove the just created trigger and the postgresql procedure and make such a mistake.

    I tried to follow the men and make the current user owner of the base I work with. Though he seemed to be the owner. http://www.postgresql.org/docs/9.1/static/sql-alterdatabase.html It's written. I have the same power to grant all the rights it says. http://www.postgresql.org/docs/9.1/static/sql-grant.html

    SQL for disposal looks like:

    DROP TRIGGER IF EXISTS update_params ON XXX CASCADE;
    

    Help me figure out what's going on?



  • Remote sequence is important. It helped remove the procedure first and then the trigger.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2