Search
Search

How to find login name in SQL Server from a user_name of database

Kira Published at Dev
29
Kira

How can I find login name in SQL Server from a user_name of database using a stored procedure?

Serg

For example you can use the system functions

declare @uname sysname = 'dbo'; -- user name in question
SELECT suser_sname(user_sid(USER_ID(@uname))) as login

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

How to pass user_name based on the user_ID from login page to home page using mvc

Change Login name (Windows user) for an existing SQL user on the Database server

How to find a specific name from a string in sql server table data

How to parameterize database name in SQL Server

How to use database name dynamically in SQL Server

Error in SQL Server when connecting to PowerBI Datamart [Unsupported sql function USER_NAME]

how to get user_name from the title that has "eJx2" in it from this json array?

Drop user without a name from sql database

Login Authentication from SQL Server database

Remove database name from ODBC (SQL Server) table list

SQL Server Express login failed for user domain\name

How to get another table from the same sql data source without having to type the server name and database name again?

How to find the database name using the table name?

How to get index names for all databases by database name on a SQL Server

How to drop a database if a variable with its logical name exists in SQL Server?

How to get the schema name for sysobjects when querying a sql server database

How to search a column name in all tables in a database in SQL Server 2012?

How to get SQL Server database name without logging in?

EF Core migrations SQL Server - how to get database name?

SQL Server: How to use a database name as a parameter in a stored procedure?

How to Know who creates (host name) a database in sql server?

How can I change database name in Sql Server with code?

How to find JNDI name when creating entity classes from a database?

How to find user name from the session ID?

How to find already installed sql server 2014 instance name and version?

How to find the name of not-null constraints in SQL Server

How to retrieve last login for each user from SQL Server?

How to find the domain name of a server?

Find a column name from all tables and all databases with specified column name SQL Server

TOP Ranking

  1. 1

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  2. 2

    pump.io port in URL

  3. 3

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  4. 4

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  5. 5

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  6. 6

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  7. 7

    BigQuery - concatenate ignoring NULL

  8. 8

    Modbus Python Schneider PM5300

  9. 9

    Make a B+ Tree concurrent thread safe

  10. 10

    What is the exact difference between “ use_all_dns_ips” and "resolve_canonical_bootstrap_servers_only” in client.dns.lookup options?

  11. 11

    Svchost high CPU from Microsoft.BingWeather app errors

  12. 12

    3D Touch Peek Swipe Like Mail

  13. 13

    Printing Int array and String array in one

  14. 14

    java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

  15. 15

    UWP access denied

  16. 16

    Emulator wrong screen resolution in Android Studio 1.3

  17. 17

    Google Chrome Translate Page Does Not Work

  18. 18

    Apache rewrite or susbstitute rule for bugzilla HTTP 301 redirect

  19. 19

    Can a 32-bit antivirus program protect you from 64-bit threats

  20. 20

    Is there an option for a Simulink Scope to display the layout in single column?

  21. 21

    Unable to use switch toggle for dark mode in material-ui

HotTag

Archive