It is very important, that NO user can connect to the db as Sysdba!!
Think of all the BS they can do with the DB, from shutting it down to
changing metadata to completely destroying it.....

Interbase was the first RDBMS at all to offer a role-based
privilege-system, so why not use it?
Create a few roles, grant the proper privileges to them and after that,
simply grant the desired role to the users.
This will result in less headaches in configuring the access-rights, and
even lesser headaches in maintenance, especially when changing rights.
Especially when treating with sensible information proper
user-management will be essential....think of an purchasing system,
where employees and partners can take a look at pricelists....you really
don't want the partners be able to see the margins for your products,
don't you?

For more info on roles, see http://www.ibphoenix.com/ibp_sqlroles.html

Cu, Nick

> -----Ursprungliche Nachricht-----
> Von: Marcello Miorelli [mailto:jjkalki@...]
> Gesendet: Mittwoch, 23. Mai 2001 00:47
> An: ib-support@yahoogroups.com
> Betreff: [ib-support] Users
>
> Hello dear all,
> I have some doubts regarding the use of users in Interbase.
> Is it better if every user has its own id, or everyone can use a

single

> user
> like SYSDBA, for instance?
> Then if it is better, how do I use create user, grant, revoke and so

on

> through a Delphi program?
>
> What happens regarding the database performance?
>
> Does someone has some example for sharing?
> Or just some SQL example.
>
> Thanks in advance.
> Marcello
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/