| |

VerySource

 Forgot password?
 Register
Search
View: 564|Reply: 2

How do I add a user in SQL Server?

[Copy link]

1

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-3-9 20:00:01
| Show all posts |Read mode
How do I add a user in SQL Server?
Reply

Use magic Report

0

Threads

28

Posts

25.00

Credits

Newbie

Rank: 1

Credits
25.00

 China

Post time: 2020-6-5 16:15:01
| Show all posts
--The example is for user Albert to create a SQL Server login with a password of B5432-3M6, and the default database is corporate.

EXEC sp_addlogin'Albert','''B5432-3M6','corporate';
GO
Reply

Use magic Report

0

Threads

28

Posts

25.00

Credits

Newbie

Rank: 1

Credits
25.00

 China

Post time: 2020-6-5 22:15:01
| Show all posts
---Do not specify the default database User name test password: aa
EXEC sp_addlogin'test','aa'
GO
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list