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
:-)

Alan
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Dennis
Cons
Sent: Thursday, 5 September 2002 19:48
To: ib-support@yahoogroups.com
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
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



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



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