check access in database

[peac3]

Hi guys,
is there any other way to know whether we have access to this database other than via security -> users?

I have access to this database but I couldn't see my name in that list,
but I have checked via sysusers, I can see my name in there.

Thanks guys

 

[TysonLPrice]

This is for SQL 2005 and will show you what roles you are in:

DECLARE @username NVARCHAR(128); 
SET @username = 'YOURLOGIN';  
WITH CTE_Roles (role_principal_id) 
AS 
    ( 
    SELECT role_principal_id 
        FROM sys.database_role_members 
     --   WHERE member_principal_id = USER_ID(@username) 
        UNION ALL 
    SELECT drm.role_principal_id 
        FROM sys.database_role_members drm 
                INNER JOIN CTE_Roles CR 
                ON drm.member_principal_id = CR.role_principal_id 
    ) 
SELECT DISTINCT USER_NAME(role_principal_id) RoleName 
    FROM CTE_Roles 
    UNION ALL 
SELECT 'public' 
    ORDER BY RoleName;