My department wants to limit tables/views/stored procs based on database role.
Posted on 2007-11-20
My colleague and I have been tasked with creating SQL Server 2005 application roles and restricting users with those roles from being able to see tables. In my C# code, how do I know if a user belongs to that role created? I am familiar with WindowsIdentity and WindowsPrincipal classes but those are more at the operating system (or network), not at the database. I have not found much information on how to do this.