Grant select on DBC.USERS for typicall user.

Database
Enthusiast

Grant select on DBC.USERS for typicall user.

Welcome,

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.

Regards,

wookie

Tags (2)
2 REPLIES
Junior Contributor

Re: Grant select on DBC.USERS for typicall user.

Hi Wookie,

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'.

Dieter

Enthusiast

Re: Grant select on DBC.USERS for typicall user.

Hi there,

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