I have tried to grant select on dbc.users table for one user.
For some reason default command does not give the right result.
grant select on dbc.users for uset_name
When user selects top 10 * from dbc.users, SQL returns only his login :/
Any sugestion might be handy.
dbc.UsersV is a restricted view but without the X.
You should use dbc.DatabasesV which holds both databases and users, there's a DBKind column indicating 'D' or 'U'.
Thanks for your answer.
Well till now I have used dbc.databases but this table does not have information about user profile and others which dbc.users have.
But thanks anyway :)
Typical grant to select on dbc.users is not that simple thing to do. Whole DBC.USERS read is somehow scripted or sth else so typical grant will not help.
Pretty strange stuff ;P