Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
antoedinchar...@gmail.com wrote: > 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

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-29 Thread antoedinchar...@gmail.com [firebird-support]
Have planned the upgrade of FB, and the works are going on.

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-29 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 29-9-2018 08:22, antoedinchar...@gmail.com [firebird-support] wrote: > Firebird-2.5.2.26540_0_Win32 is the firebird i am using. Not related to your question, but why are you using such an old version? The latest 2.5 is 2.5.8 (with 2.5.9 around the corner), and the version you are using has

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-29 Thread antoedinchar...@gmail.com [firebird-support]
User under manager role should be able to view/modify the procedure and trigger whereas user those are not under manager role should not be able to modify the procedure, they should only be executing the procedure.

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-29 Thread antoedinchar...@gmail.com [firebird-support]
Hi, Firebird-2.5.2.26540_0_Win32 is the firebird i am using.

Re: [firebird-support] Firebird - GRANT edit/recreate access to specific users and block some users from editing/recreating the procedure

2018-09-27 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
antoedinchar...@gmail.com : Not enough information. What version of Firebird are you using? > I am trying to GRANT edit/recreate procedures for manager level > users and blocking the same from normal users. Explain exactly what you mean by "manager level users". > I was able to do the same in