----- Original Message -----
From: <sjohnson@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 08, 2001 8:21 PM
Subject: [IBO] List of Roles in a database
> I have used the LoginSQLRoleList property to store a role "list" that
> the user can choose from. I would like to determine all the roles
> contained in the database, our users often add to the default roles.
>
You can use this SQL statement:
SELECT RDB$ROLE_NAME,RDB$OWNER_NAME
FROM RDB$ROLES
This return ALL roles and it`s owners from database... But before connection
?-)... I use small utility for obtain list of roles (not in main
application) and save this list to text file for future use...