Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- C:\>sqlcmd -S localhost -U sa -P 1234
- 1> -- Set TriadWorksDb as the current database
- 2> USE TriadWorksDb;
- 3> GO
- Changed database context to 'TriadWorksDb'.
- 1> -- Create a new server login name: rponte
- 2> CREATE LOGIN rponte WITH PASSWORD = 'TopSecret'
- 3> GO
- 1> -- Create a new database user linked to the login name
- 2> CREATE USER rponte FOR LOGIN rponte;
- 3> GO
- 1> -- Grant database ALTER permision to the user
- 2> GRANT ALTER To rponte;
- 3> GO
- 1> -- Grant database CONTROL permision to the user
- 2> GRANT CONTROL To rponte;
- 3> GO
Add Comment
Please, Sign In to add comment