SQLTeam.com | Weblogs | Forums

Check Login stored proc in sql server


#1

How to create check login proc in sql server.
plz advice me


#2

maybe

select SYSTEM_USER


#3

Goodmorning sir
I am new in sql server. plz provides details...


#4

Do you want to audit a particular login?


#5

Yes sir...


#6

you can use the builtin audit feature under security in SQL Server management studio.


#7

check login for e-comm project in sql server


#8

You have to understand that we have no idea what you want for any of this.

Are you asking for how to check a login for which databases it has access to a what privs it has for each database and at the server level?

Or, are you asking if a login for a particular application simply exists and that they've used a correct password to login?

Or something else?


#9

login for a particular application simply exists and that they've used a correct password to login?


#10

If you want to create a login procedure. This may help you: https://www.codeproject.com/Questions/375629/stored-procedure-for-login