on 10-13-2014 6:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Mark,
Many thanks for your reply .I am new to Sybase IQ world.
Could you please let me know whether we need to manually grant roles and priviliges while moving owner ship of the objects or does the alter owner implicitly takes care of it and transfers the roles and privilges accordingly.
Regards,
Arun
Oh, I see. What a pitty! What we want to do is to change the owner to 3,000 tables!!!
Is it possible to use an alias for the owner?. I mean when I want to query a table named "owner1.table1" I am really querying the table named "t1g.table1" (a sort of SYNONYM
used in Oracle).
BTW, thanks for your prompt responses!
Mariano
Unfortunately, SAP IQ does not support changing the owner of a procedure. You would have to drop and recreate the procedure.
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.