OK,
there's something I'm obviously missing here (newbie to this).
In Enterprise Manager I've Created a new role on my database called FinanceStaff.
I've added my login as a member of this role (SQL is using NT Authentication)
From Access I run this view
SELECT IS_MEMBER('FinanceStaff') AS Member, SYSTEM_USER AS SystemU, CURRENT_USER AS CurrentU
and get the following results:
0, MYDOMAIN\USERNAME, dbo
Can someone help me understand why the Member column is returning 0 instead of 1?
What am i doing wrong?
All help gratefully received.
M.
there's something I'm obviously missing here (newbie to this).
In Enterprise Manager I've Created a new role on my database called FinanceStaff.
I've added my login as a member of this role (SQL is using NT Authentication)
From Access I run this view
SELECT IS_MEMBER('FinanceStaff') AS Member, SYSTEM_USER AS SystemU, CURRENT_USER AS CurrentU
and get the following results:
0, MYDOMAIN\USERNAME, dbo
Can someone help me understand why the Member column is returning 0 instead of 1?
What am i doing wrong?
All help gratefully received.
M.