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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2004-02-25 : 08:19:24
|
| Hello All.I have to create a new user account in sql. I would like the user to have insert/update/delete/select rights to only 1 table. However, when he runs query analalyzer and enterprise manager, I do not want him to be able to see a listing of all the table, views sprocs, etc... in the database. Only the one that he has access to should show up.Can anyone help me out? thanks. |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2004-02-25 : 08:19:50
|
| . |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-25 : 08:22:05
|
| Don't give him Enterprise Manager, unless he's an administrator he shouldn't have it anyway. You can't prevent objects he has no rights to from showing up. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2004-02-25 : 08:25:34
|
| He's actuall a SQL administrator on another domain and I'm setting him up so that he can replicate one table that I need to my database.A few years back, the DBA here did the same for me when I was starting out. I could login, but I couldn't see any database objects, only the ones I was supposed to be working with. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2004-02-25 : 08:29:02
|
| I'd hate to have to create a brand new database for this just so he can replicate one table... |
|
|
|
Mathias
Posting Yak Master
119 Posts |
Posted - 2004-02-27 : 07:28:38
|
| Hi,I think you need to restrict access to sysobject table. Regards, Paul |
|
|
|
|
|
|
Security question.