Access in AS Database

I have a scenario where I need to give access for one of my subordinate to the AS database on my AS Server. He should have the ADMIN rights to only that AS database. I cant give him rights to the Server box as it contains other AS databases too. Is it possible to give him such rights in AS 2000. so that he registers the server from any other machine and gets to see only that database. Also can we restrict his rights to cube level if we want to do so.

Thanks in Advance,
siaj

Hi,

You will need to create the database yourself (because this requires admin per server) and inside the database create a Role containing your subordinate account. Then, for that Role specify admin permissions for the database.

After this, the subordinate can connect to your server and he will be able to fill the database with dimensions, cubes, mining structures etc. However, he needs to be carefull to not delete that database Role (who contains him as member) or he will cut his access. Therefore, if the subordinate will use a BI project to deploy, he needs to make sure that the project contains the Role definition. If he will connect to the database to adminsiter it online, there shouldn't be problems.

Adrian Dumitrascu.