Re: Application role

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 03/25/03


From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Tue, 25 Mar 2003 07:35:19 -0600


SELECT USER will return the application role name once the app role is
activated.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Darko Grujic" <darkogrujic@hotmail.com> wrote in message
news:38d801c2f2bb$74e0a240$2f01280a@phx.gbl...
> Is it possible to check that an application role has been
> activated by an application?
>
> Darko


Relevant Pages

  • Re: Application role on connection
    ... SQL Server MVP ... SQL FAQ links (courtesy Neil Pike): ... > connection and that using application role. ...
    (microsoft.public.sqlserver.security)
  • Re: Application role on connection
    ... SQL Server MVP ... SQL FAQ links (courtesy Neil Pike): ... > connection and that using application role. ...
    (microsoft.public.sqlserver.security)
  • Re: Security Script
    ... SQL Server MVP ... SQL FAQ links (courtesy Neil Pike): ...
    (microsoft.public.sqlserver.security)
  • Re: finding instances of SQL Server
    ... SQL Server MVP ... SQL FAQ links (courtesy Neil Pike): ... > about 1000 computers are running MSDE or SQL Server? ...
    (microsoft.public.sqlserver.security)
  • Re: Problems with SQL Login Passwords
    ... Here's a shorted url version of the post I was referring to: ... SQL Server MVP ... >>SQL FAQ links: ... >>> I create a SQL login and set the password and confirm ...
    (microsoft.public.sqlserver.security)

Quantcast