Subject Re: [ib-support] How to create a new user equal to sysdba
Author Helen Borrie
At 09:00 PM 23-07-02 -0700, you wrote:
>Dear IBgroupies,
>I need to create a new user to perform sysdba functions because I have to
>log on with a specific userid supplied by my ISP in order use IBconsole to
>manage my database.
>I can create users with IBconsole, and I can see how to create roles and
>assign priviledges like select,update ....etc
>How do I assign the same priviledges (e.g. table create ....everything like
>a sysdba) to my new user.

The answer is that you can't. The sysdba user has the entire server as its
scope. No right-thinking ISP will let any of his customers loose as
sysdba, with destructive rights to every database on his server.

What you need, to have a user with similar rights to sysdba *within your
database* is have that user CREATE the database, thereby making it the
OWNER of the database. What that means to you is that you will have to
make a gbak of the database (as sysdba) and then restore it (somewhere
else) when logged in as the user which you want to be the owner.

I think also that you are labouring under an illusion if you thought a
non-sysdba user could create user accounts. This will only be possible on
your ISP's server if their sysdba has granted suitable rights to your
userid in the USERS table in their server's isc4.gdb. Again, isc4.gdb is
server-wide in scope and I doubt an ISP would give clients any
rights. Possibly the ISP has a server-based application tier that is
designed to intercede in client requests to perform admin tasks...


All for Open and Open for All
Firebird Open SQL Database · ·