June 30, 2011 at 9:02 am
I have created new user and changed the password when i login for the first time.
Steps Followed:
1.Done login using Windows Credentials
2.Right Clicked Security and Selected new login
3.Created credentials.
4.Clicked Server Roles kept it as 'Public'
5.In user mapping selected all the databases and kept the database role membership as public
(please suggest me do i need to select any other role)
6.Selected the authentication as SQL Server and windows authentication mode
7.Disconnected database engine and connected using the new credentials and changed the password
here i can see all the database but i am not able see the tables under each database. First time i am creating user because i need to use this credentials SSIS. plz help me regarding this.
June 30, 2011 at 10:42 am
5.In user mapping selected all the databases and kept the database role membership as public
(please suggest me do i need to select any other role)
If you want to read data you would also need to select the db_datareader role. You should google SQL Server database roles to get a better understanding of what each role can do for you and select accordingly.
June 30, 2011 at 12:15 pm
Thanks this was very useful. I needed ready only permission. Now i am able to access all databases in SSIS using SQL Server Authentication.
Definitely will go through all the roles.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply