| Subject | Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure |
|---|---|
| Author | Helen Borrie |
| Post date | 2018-09-29T20:27:32Z |
antoedincharley@... wrote:
a point release, i.e., the same software with patches. You need to do
this. Just keep safe copies of security2.fdb, firebird.conf and
aliases.conf, so you can copy them back over the new ones.
Regarding your original question, see
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-rdbadmin
Grant the RDB$ADMIN role to the user(s) you want to have SYSDBA rights
in the database. When that user logs in with that role s/he can do
what you asked for. If s/he logs in without that role, s/he will have
just the rights that have been otherwise granted.
HB
---
This email has been checked for viruses by AVG.
https://www.avg.com
> Have planned the upgrade of FB, and the works are going on.Firebird 2.5.2 to Fb 2.5.8 is not an upgrade you have to plan. It is
>
a point release, i.e., the same software with patches. You need to do
this. Just keep safe copies of security2.fdb, firebird.conf and
aliases.conf, so you can copy them back over the new ones.
Regarding your original question, see
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-security-auth.html#fblangref25-security-rdbadmin
Grant the RDB$ADMIN role to the user(s) you want to have SYSDBA rights
in the database. When that user logs in with that role s/he can do
what you asked for. If s/he logs in without that role, s/he will have
just the rights that have been otherwise granted.
HB
---
This email has been checked for viruses by AVG.
https://www.avg.com