is_member('urole') returns 0 for windows account belonging to user-defined role 'urole'
From: marc m. (_@_)
Date: 03/12/03
- Next message: Manoj: "Script for sql logins"
- Previous message: Jim Howell: "xp_qv -- Extended Stored Procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "marc m." <_@_> Date: Wed, 12 Mar 2003 16:05:16 +0100
My application employs role-based security and checks whether a connected
user is member of a specific role 'config' using is_member('config').
However, although the user/login - a windows account - is configured to be a
member of this role, is_member('config') returns 0. This works fine if the
user connects with a SQL Server login.
How do I get this to work for windows accounts ?
- Next message: Manoj: "Script for sql logins"
- Previous message: Jim Howell: "xp_qv -- Extended Stored Procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
