| Author |
Topic |
|
wendy
Starting Member
19 Posts |
 Posted - 2005-11-08 : 13:22:27
|
| Hi,Does anyone ever have the problem to view Databases from enterprise manager? Any user permission is needed except SA right?Thanks,-Wendy |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-11-08 : 13:43:41
|
| I have a user who doesn’t have the SA privilege is having trouble to view databases from enterprise manger. My question is in order to do this , any user permission is needed?ThanksWendy |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-08 : 14:27:54
|
| What do you want them to do?You can give them dbo, which means they can do anything to that database, or they can have just datawriter which will allow them to modify data, or they can be just datareader so the can only perform read only operations.What do they have now?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-09 : 02:04:52
|
| users are only allowed to view databases they have permissions toto enable them to view the other databases, you need to grant them access--------------------keeping it simple... |
|
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-11-09 : 08:58:03
|
| The issue is the user is the DBO for the DBs, but at database fold in the enterprise manager there is any database listed.Thx,-Wendy |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-09 : 10:05:05
|
| Wendy,Where are you from?Your wording is a bit misleading.I assume you mean but at database folder in the enterprise manager there isn't any databases listed.Did they register the Server? Do they have the right instance?Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-11-09 : 10:16:18
|
| Sorry, it is what I mean “at the database folder in the enterprise manager there isn't any databases listed".Yes, they registered the Server for the right instance and they can connect the query analyze to view all tables etc. with no issues.Thx-Wendy |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-11-09 : 11:25:35
|
| No. All DBs were there and users had no this issue before. There are no any permissions changed recently in the server.Wendy |
|
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2005-11-09 : 16:41:04
|
| try right click and refresh"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-11-09 : 21:35:37
|
| ah, i misinterpreted the first post from wendyso what you're saying is that the dbo is not able to view the objects in EM but can in QA?Have you tried removing the user and adding it back with DBO privilege? If yes and still problem exists, what we did before is to have the tools reinstalled.HTH--------------------keeping it simple... |
|
|
|
wendy
Starting Member
19 Posts |
Posted - 2005-11-10 : 16:22:56
|
| Hi,By working with Microsoft Support, this issue has been fixed. The reason for EM failing under this user account is for some reason this user has access denied on TEMPDB.Thanks all for your help.Wendy |
|
|
|
|
View Databases from enterprise manager