WinSQL » Knowledge base

Document information

Document ID:1272
Subject:Tables appears to be owned by ADMIN in Netezza
Creation date:3/4/10 12:57 PM
Last modified on:3/4/10 12:59 PM


Table ownership is incorrect in Netezza


The default behavior is to use the database owner as the schema for every table in the database and not the user who created the table. For example, when you login as JOHN and create a table called MYTABLE, you will see the newly created table as ADMIN.MYTABLE in Netezza rather than JOHN.MYTABLE.

To change this default behavior submit the following query to your database.

update _t_odbc_feature
set enabled=1
where feature=16


These statements would need to be run as the ADMIN user connected to the SYSTEM database




Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com