SQL server user permissions

[sandi]

Hi guys,

I have another question for you. I'm using SQL server (RDBMS) and now I would like to ask you what kind of permissions on the EA database a user needs to be able to work(no admin features! - only minimum premissions that the regular user is able to work)?

Thank you,
 S.

[Bruno.Cossi]

Hi Sandi,

I am away from our MS SQL Server now, but off the top of my head, the user needs the Select, Update, Insert and Delete permissions on all of the EA tables (see the repository creation SQL script for the list of the tables). As a matter of fact, for some of the tables (the lookup ones) the user in theory needs only Select, I could lookup the list of those tables, if necessary.
The user does not require any of the admin privileges, does not need to create new or alter the existing database structures etc.
Hope this helps.

Bruno

[sandi]

Oh, thank you Bruno.

Meanwhile what I tried, is to enable Select on all tables, Update on all tables ... and I finally get to the conclusion that all of those permissions are required mentioned in your post.

Hard work.

Thanks again!

[Bruno.Cossi]

You're welcome! :-)

Bruno