I need to be able to establish an ODBC connection through SQL Server authentication.
How can I grant permissions for an user with ALL rights on DB?
Please help :)
I found solution:
CREATE DATABASE <DB name> CREATE LOGIN <login name> WITH PASSWORD = 'aaaaaa' with default_database = <DB name> GO USE <DB name> CREATE USER <User name> FROM LOGIN <login name> EXEC sp_addrolemember 'db_owner', '<User name>' GO
It's all :)
FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.
Boost your productivity with FavScripts.com!