Subject RE: [ib-support] To grant "alter table type" priviledges ?
Author Alan McDonald
SYSDBA is the owner at the moment and therefore is the only one with the
grant option.
To avoid a rebuild you need to have another user installed (by your ISP if
you no longer have access) and have all tables/procedures etc granted all
with grant option to the new user . Sometimes a rebuild is a better option

-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Dennis
Sent: Thursday, 5 September 2002 19:48
Subject: [ib-support] To grant "alter table type" priviledges ?

IB v6

I have created all my tables with sysdba. I now need to be able to make
table changes using another user (db is running at an isp, I don't get
sysdba access). And I don't want to rebuild my database.

Can you grant "alter table" type priviledges to another user. Or change
ownership of a table.

Thanks Dennis Cons.

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]