Permissions on database (SQL-Server)

security Supervisor (4.x - 6.x)
1

Hi there,

Does anybody knows which permissions I need for the useraccounts on SQL-Server?

UserAccount 1, used for the repository connection (bomain.key)

UserAccount 2, used for accessing the tables (run query’s)

Thanks for your input.

Regards,

Vides TamaÎla

PROPHECY (http://www.prophecy.nl)
Villawal 7
3431 AH Nieuwegein
The Netherlands

Tel: +31 (0)30 6050744
Fax:+31 (0)30 6050690

Email: v.tamaela@prophecy.nl (business)
Email: maeva@wxs.nl (private)

Listserv Archives (BOB member since 2002-06-25)

2

You need read/write on the repository and read only for user queries. Initially, the repository id needs create table/index privileges also. These can be removed after the repository has been created.

Listserv Archives (BOB member since 2002-06-25)