Friday 14 February 2014

Change the Owner of Sequence




If you want to change the Owner of Vertica sequence number, connect data base with super user(dbadmin) and follow the below syntax.

One table: 
ALTER SEQUENCE <Schema Name>.<Table Name> OWNER TO <User Name>

Multiple tables: Capture the below query result and execute through dbadmin
SELECT 'ALTER SEQUENCE <Schema name>.'||SEQUENCE_NAME||' OWNER TO <New User>;'
FROM V_CATALOG.SEQUENCES WHERE SEQUENCE_SCHEMA='<Schema Name>' AND OWNER_NAME = '<Existing User>'

No comments:

Post a Comment