开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜