创建用户问题

Question

创建一个用户，和一个与用户同名的数据库。
并赋予db_owner权限~~SQL语句怎么写。。？

Answer 1

USE [db_name] 
GO 
CREATE USER USERNAME FOR LOGIN USERNAME 
GO 
USE [db_name] 
GO 
EXEC sp_addrolemember N'db_owner', N'USERNAME' 
GO  

Answer 2

--创建一个Poofly（密码kkkkkkk）登入账号,并为其指定创建一个Poofly用户,默认架构为feixianxxx
CREATE LOGIN poofly 
    WITH PASSWORD = 'kkkkkkk';
USE dbname;
CREATE USER poofly FOR LOGIN poofly 
    WITH DEFAULT_SCHEMA = feixianxxx;
GO
---检查当前用户名和登入账号之间的映射
SELECT s.name as [Login Name], d.name as [User Name], 
     default_schema_name as [Default Schema]
   FROM sys.server_principals s 
      JOIN sys.database_principals d
   ON d.sid = s.sid;
GO
/*
Login Name                                                                                                                       User Name                                                                                                                        Default Schema
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
sa                                                                                                                               dbo                                                                                                                              dbo
poofly                                                                                                                           poofly                                                                                                                           dbo(2 行受影响)*/

Answer 3

-- 创建登陆帐户
create login usr with password='', check_policy=off;
go
-- 创建数据库
create database usr;
go
-- 修改数据库的所有者
alter authorization on database::usr to usr;
go

Answer 4

oracle  的SQL> create user bing identified by bing;用户已创建。