SQLTeam.com | Weblogs | Forums

Login rights


#1

Hallo,

I would like to create a database that has different tables . I am also creating a front end, thata connecting to the table. Is it somehow possible to create a logins so not everyone can see all the tables and the fields in the database?


#2

Yes. Create a login. Create a role in the database. Create a user in the database that is attached to the login. Add the user to the role. Grant the role whatever permissions you want it to have. I recommend data access be through stored procedures, so that's the permissions that I would add.


#3

aaah, nice to read that is possibile. Do you know if there is, somewhere, a tutorial available about how to get that done so i will not make any mistakes?


#4

Anyone with a turorial link for that specific problem?