创建数据库
create database test2
-创建登陆帐户
create login angel1 with password='abcd1234@', default_database=test2
创建数据库用户(create user):
create user angel1 for login angel1 with default_schema=dbo
授权
exec sp_addrolemember 'db_owner', 'angel1'
ALTER AUTHORIZATION ON DATABASE::test2 TO angel1
SELECT name, database_id, is_trustworthy_on FROM sys.databases; --0 为关闭 1为开启
要打开数据库trustworthy属性,命令如下:
ALTER DATABASE 数据库名 SET TRUSTWORTHY ON
授权用户访问,命令如下:
ALTER AUTHORIZATION ON DATABASE::数据库名 TO [用户名]
ALTER AUTHORIZATION ON DATABASE::test2 TO angel1
删除登入用户
EXEC sp_dropuser 'angel'
删除数据库用户
EXEC sp_droplogin 'angel'
create database test2
-创建登陆帐户
create login angel1 with password='abcd1234@', default_database=test2
创建数据库用户(create user):
create user angel1 for login angel1 with default_schema=dbo
授权
exec sp_addrolemember 'db_owner', 'angel1'
ALTER AUTHORIZATION ON DATABASE::test2 TO angel1
SELECT name, database_id, is_trustworthy_on FROM sys.databases; --0 为关闭 1为开启
要打开数据库trustworthy属性,命令如下:
ALTER DATABASE 数据库名 SET TRUSTWORTHY ON
授权用户访问,命令如下:
ALTER AUTHORIZATION ON DATABASE::数据库名 TO [用户名]
ALTER AUTHORIZATION ON DATABASE::test2 TO angel1
删除登入用户
EXEC sp_dropuser 'angel'
删除数据库用户
EXEC sp_droplogin 'angel'