Question & Answer
Question
How do I change the owner of a table?
Answer
You can change the owner of a table using the following SQL statement:
- ALTER TABLE table OWNER TO user_name
For this to be valid, the user must have the ALTER TABLE privilege.
Note that prior to NPS Release 2.5, you must contact Customer Support to change the owner.
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ570110
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21573513