SQL Server: login

Create a login with a password

create login [foo-bar-baz] with password = 'X$!…'

--
-- MUST go to database!
--
use tq84_db;

create user user_01 for login [foo-bar-baz] 
 
grant control on database::tq84 to user_01;

Create login with Windows authentication

create login [domain\user.name] from windows;

select
   suser_sname(sid) user_of_sid,
   type_desc,
   default_database_name,
   create_date
from
   sys.server_principals
where
   name = 'domain\user.name'

--
-- MUST go to database!
--
use tq84_db;

create user rene for login [domain\user.name]

select
   dp.name,
   dp.type_desc               ,  -- WINDOWS_USER
   dp.authentication_type_desc, -- WINDOWS
   dp.create_date
from
   sys.server_principals   sp join
   sys.database_principals dp on sp.sid = dp.sid
where
   sp.name = 'domain\user.name'
   
grant select on some_table to rene;

See also