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