Re: How to check user logon belong to a sql role?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Paul (paul_mak@xxxxxxx) writes:
In a Sql database I create a Database Role and assign Windows users to
the role. I want to use it as a security for an ,net application when
user logon passing as a parameter on a store procedure to validate if
the user logon have permission to any of the database objects. How to
achieve this? How to write this store procedure? Thanks

Have a look at the is_member() function in Books Online.

For further questions, plsase specify which version of SQL Server you
are using.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: dbrpcparam datalen problem
    ... I tried to use it for the store procedure call: ... and which the version of SQL Server following SQL 2008 will not support. ... not support features added in later versions. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: sql query which has got 3 dynamic parameters
    ... have a store procedure to which I pass a number which will give me a ... say if I type exec SP_FETCH_ROWS 1 ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: doing select without grant
    ... I want my users to run my store procedure without granting the select on ... grant permission to a created from the certificate. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Question about move large amount of data from database to database
    ... database table to another database table every week. ... input date range from web UI, my store procedure will take those date ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Slow windows user logon
    ... Is it possible that SQL Server 2005 express "locks" the computer for several minutes during a domain user logon? ... We are using the "sa" account to use the SQL Server from our programs. ... I have a distributed network with one domain controller and a lot of XP clients connected to that domain. ...
    (microsoft.public.sqlserver.setup)