Stored Procedure- Special Account

I have a requirement to execute a stored procedure and fetch data from a table. I need to create an account in SQL and use the same. (SQL 2005)

I need to create an account in SQL. I can create that. But How do I Use that account to run the stored procedure and the table(to get data out of table)

Tha开发者_如何学JAVAnk you

I depends upon which client you use, but you can simply change your connection string to use standard security

e.g.

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

See connection strings for your specific needs