News

CREATE USER (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw] Adds a user to the current database. The 12 types of users are listed below with a sample of the most basic syntax: Users based on logins ...
If you do not want password authentication for the user, omit the PASSWORD option. SUPERUSER Grants the user superuser permission. A superuser can override all access restrictions. NOSUPERUSER is the ...
where PASSWORD is a strong and unique password. Grant the user the rights to create new users and the ability to reload on global rights with: grant create user, reload on *.* to 'dbadmin'@'%'; ...