Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hvdtol
Yak Posting Veteran
50 Posts |
 Posted - 2002-08-14 : 11:27:15
|
| I hope somebody can push me in the right direction with a security problem i have.A user of us, wants to acces some tables in a userdatabase i created.He does this with Ms-Access, using a ODBC connection.I have created user login with a default database refering to this database.He is only authorised for selecting the tables, which works with the role i created.But, When he makes the connection to the database, all other tables are shown as well (like the sys* tables in this user-database).How do i prevent from showing (=viewing) these other tables to him?Hope somebody can help me in this.Thank you in advance.Best regards,Harry van der Tol |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-14 : 11:40:02
|
| A quick read through the "Managing Security" section of Books Online will do you well.You'll probably use the DENY keyword.Jay White{0} |
 |
|
|
igoro1975
Starting Member
7 Posts |
Posted - 2002-08-14 : 14:10:55
|
| At first, sorry for my English.Maybe you need to grant the user only public role permission and in the role to grant only one table permissions.I've done so."I do not fear computers. I fear lack of them." - Isaac Asimov |
|
|
|
hvdtol
Yak Posting Veteran
50 Posts |
Posted - 2002-08-14 : 15:42:09
|
| Oke,Thanks you both, for your reply.I will try and concentrate on both options.Thanks |
|
|
|
|
|
|
Prevent user viewing other tables in DB