SQL Server -> Sybase
Can you please help me convert this T-SQL SQL Servers to Sybase compatible sytax
I've been googling it but can't find anything, I'm prob searching for keywords that don't exist in Sybase!
Here is what开发者_运维百科 I trying to convert
CREATE LOGIN bcpuser WITH PASSWORD = 'bcppassword'
CREATE USER bcpuser FOR LOGIN bcpuser"
sp_addrolemember 'db_owner', 'bcpuser'
Thanks a lot
To Create Login
sp_addlogin bcpuser, bcppassword
To Grant Role
sp_role "grant", sa_role, bcpuser
Raymund has provided most of it. Same as MS< User is at the db level.
sp_adduser login_name
精彩评论