Skip to Content

how to change ownership of tables , views and other objects in sybase iq.

Hello,

Could you please let me know how to change ownership of tables , views and other objects in sybase iq?

I guess the sybase command alter table <owner.tablename> modify owner <newowner> does not work in sybase iq ?

Regards,

Arun

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 13, 2014 at 07:11 PM

    Hello Arun,

    You can use this

    ALTER TABLE table_name ALTER OWNER TO new_owner

    Since views take just a second to create, I think the best path for those is to drop and recreate.

    Mark

    Add comment
    10|10000 characters needed characters exceeded