July 1, 2006 at 11:59 pm
hi guys,
how can i get the database list, using sql statements, that the current login user can vist? i know the enterprise manager can show this list when viewing the user's properties.
thank u.
July 2, 2006 at 8:12 am
sp_MSdbuseraccess
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
July 3, 2006 at 7:04 am
July 3, 2006 at 7:49 am
sp_MShasdbaccess
July 3, 2006 at 9:52 am
thank you all,
to Johnson, sp_mshasdbaccess works well.
to Roi Assa , sp_helprotect null, 'User_Name' lists all the current user's rights in the current database,
to stax88, sp_MSdbuseraccess not exist, maybe you mean sp_mshasdbaccess?
July 3, 2006 at 1:43 pm
Sorry, I'm using v9.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply