I have one database per user of course.
But how can I grant (or specify) which user is owner of a database?
So I would have i.e. 10 users and their 10 databases (with aliases).
Should I create a db with account of each user or
is there a way to create as sysdba and then grant a db to user?

Michal


GrumpyRain wrote:

>Why don't you have separate databases for each of the users, giving
>them separate aliases?
>
>--- In firebird-support@yahoogroups.com, Michal �erav�k <michalz@o...>
>wrote:
>
>
>>Hi there,
>>
>>I'd like to use FB in production web server so I need to separate users
>>and their databases.
>>When I create user account in gsec and create database as this user
>>(owner), it's ok.
>>But how can I change (alter) database owner.
>>I need each user has his own database with no access to other dbs.
>>Should I define roles, or is it matter of db ownership?
>>
>>Michal
>>
>>
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]