Interbase roles in stored procedures

[caf]

Hi

Is there anyway I can determine within a stored procedure whether the user executing the stored proceudre is a member of a particular role?
I'm using IB 6 (Open Source)

Thank You

 

[caf]

Okay, Here's the sql to the solution

SELECT a.RDB$USER, a.RDB$RELATION_NAME
  FROM RDB$USER_PRIVILEGES a, RDB$ROLES b
  WHERE a.RDB$RELATION_NAME = b.RDB$ROLE_NAME
  AND a.RDB$USER = USER

It was a stupid question, I'm sorry I posted it.

 

[MartijnTonies]

If the user has been granted multiple rows, this will return more than a single row. Keep that in mind.

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com

 

[caf]

I know.

But in my particular case a user would not be a member of two similar roles which would both have execute permission to the same procedure.

Thanks