About configuring staging database permissions
If you are a database administrator, you must configure permissions to the staging and source databases. These permissions enable users who are responsible for data integration to run stored procedures and perform necessary data movement. This topic provides links to learn how to grant access to the staging database and necessary database objects so that you can perform data integration operations. Each topic provides a sample scenario to help you review the process of assigning explicit permissions to a user.
Remember that when you assign database permissions, changing the default schema for a user is not supported. The default schema must remain set to "dbo".
Granting a user access to a database involves three steps. First, you create a login. The login enables the user to connect to the SQL Server 2005 Database Engine. Second, you configure the login as a user in the specified database. And third, you grant that user permissions to access the necessary database objects such as stored procedures.
These steps are described and listed in the following table.
Learn how to create a login for a user.
Learn how to grant access to user to a specific database.
Learn how to grant access to a user for specific database objects.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for PerformancePoint Planning Server.