By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,960 Members | 1,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,960 IT Pros & Developers. It's quick & easy.

newbie question: How to add extra SQL Auth. account?

P: 2
hi all,

I'm new to DB. I know we have a built-in account of SA. But I want to build an extra account using SQL auth instead of Windows-autho.

I can't find the interface to create an account.
Is there an interface? What would be the script to create such account?

Mar 1 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,134
You create new accounts in the security/logins branch of the server tree in enterprise manager.
Once an account is set up there then you add it to the users branch for each database that you want the user to have access to.
Once you have added the user to the database then you have to set the access privilages for each table/view/stored proc etc in the database that you want them to have access to.
Mar 1 '08 #2

P: 2
It works.
THx a lot.
Mar 2 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.