Selecting Database users
The following queries will be returning the user names
Select User
-- This displays the current user
Select User_Name()
Select Current_User
-- This displays the user belongint to ID 2
Select User_Name(2)
-- Displays all users for that DB
Select uid, name from sysusers order by uid
sysusers contain the information of all users
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment