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 :)
User rating:
User rating:
I found solution:
QRID Login
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 :)
SEND BITCOIN TIPS
User rating:
User rating:
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!
