SQL Server Repository Permissions

[PeterS]

Which permissions on which tables does a User have to have, when accessing the repository on a MS SQL Server?

[alexander]

We give the user 'ownership' of the database where EA will work.

We do this because EA uses the whole database to store the project so setting individual permissions in each table is tedius.

So the process will be:
Create a new database.
Run the script Sparx provides to create a blanck project in the Server.
Give ownership of this database to a new user (no additional permissions are required).
Use then this user and this database to open the project from EA and star using.

To manage permissions on the project i would suggest using the internal security of EA.

[PeterS]

Ok, That was my first thought too.

I do not have full access on the SQL Server machine, but I am  "owner" of the Database.
I have two users: an owner (ow) and a user which public (pu) rights. On the SQL Server  on my Database I see these two users. There I navigate to "Users" and add the 'public' (pu) user to the 'db_owner' group. I assume now, that my user 'pu' is also dbowner. But when I try to access the DB via server connection I can connect as pu but I get an error when EA tries to read the DB.

Error Message:
Micorsoft OLE DB Provider for SQL Server [-2147217865]
Invalid objName 'user_system'

[PeterS]

It is solved now.

I imported previously the .EAP (MS Access) File into SQL Server.
Somehow this was not sufficient. So I deleted everything and  used the correct EA SQL Scripts and transfered the data. Now it works fine.