Skip navigation

Netezza.comThinking.Netezza.comBookmark This Site

Up to Discussions in TwinFin Talk

12075 Views 1 Reply Latest reply: Feb 24, 2010 5:10 PM by Shawn Fox

siddavp

18 posts since
Sep 18, 2009

Currently Being Moderated

Feb 24, 2010 4:55 PM

Removing prefix admin on tablename

Just want to check if this possible

when I created a table using xyz_id (user) , table created

and when I browse from winsql/ or any other GUI tool , the object name shows ADMIN.tablename and the owner shows as xyz_id which is correct

Is there any possible you can chop the admin. before the tablename, I want to see as user_id.tablename

Like (0)

Shawn Fox
1,475 posts since
Aug 15, 2006

Currently Being Moderated

1. Feb 24, 2010 5:10 PM (in response to siddavp)
Re: Removing prefix admin on tablename

alter table <tablename> owner to xyz_id;

You would have to run that as the user admin since a normal user cannot alter the ownership of a table. If you create the table using the xyz_id user, I'd assume that you have metadata caching turned on in WinSQL and if you refresh it then it would show the correct ownership.

Report Abuse

Like (0)