Subject | Re: [firebird-support] How to give users rights to modify database |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-08-01T17:43:24Z |
> Hi!Either SYSDBA or the owner of tables, views, stored procedures ... can
> 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?
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/