pit977
Technical User
- Feb 28, 2011
- 6
- 0
- 0
Hello,
As a topic, I have 2 databases (eg. base1; base2) with the same users, could You help me how to grant permissions to a user, that he would be able to read data from another database system tables, I mean tables:
sys.database_principals
sys.database_role_members
and then use it in a query (eg, in the Where clause)
now I have message:
regards
As a topic, I have 2 databases (eg. base1; base2) with the same users, could You help me how to grant permissions to a user, that he would be able to read data from another database system tables, I mean tables:
sys.database_principals
sys.database_role_members
and then use it in a query (eg, in the Where clause)
now I have message:
Code:
The server principal "XXXX" is not able to access the database "base1" under the current security context.
regards