开发者

SQL Server -> Sybase

开发者 https://www.devze.com 2023-01-23 01:26 出处:网络
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!

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

精彩评论

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