2
votes
1answer
45 views

How do I add a user that has read access to only ONE database?

I have two databases admin and testdb ; Added a user Alice in the test database db.addUser( { user: "Alice",pwd: "Moon1234",roles: [ "readWrite" ] } ); But when I login using the user Alice, I can ...
4
votes
2answers
36 views

Easily give role in one database access to tables in another database on the same server

I have a database server (Sql Server 2008 R2 Enterprise) supporting two separate but related vendor products, each with it's own database (call them X and Y) In database X I a have a lot of users ...
0
votes
0answers
32 views

Handling data access in MS Report Builder 3.0

We have denormalised tables in our reporting database which provides data for creating ad-hoc reports in Report Builder 3.0. What is the best way to model the data access in Report Builder? The ...
3
votes
1answer
988 views

Designing An ACL Based Permission System

I am trying to create a permissions system where everything is going to be stored in MySQL (or some database) and pulled using PHP for a project management system I am building.  I am right now trying ...