Subject Re: [firebird-support] How to give users rights to modify database
Author Thomas Steinmaurer
> Hi!
> I'm using FB 1.5.
>>From time to time I have to modify my application's database structure
> along with updates to my application itself. Currently SYSDBA must log
> in first after my application is updated, so that script with database
> changes can be run.
>
> Is it possible to use ROLE or something else to give all user's the
> right to run database update script?

Either SYSDBA or the owner of tables, views, stored procedures ... can
do changes.

You'd best moving away from SYSDBA being the owner. Read my blog here:
http://blog.upscene.com/thomas/index.php?m=07&y=08&entry=entry080730-233217



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/