[Dev] What are the minimum set of SQL server permissions required for registry/um db user?

2014-05-05 Thread Charitha Kankanamge
Hi folks, I had to assign sysadmin server role to the registry/um DB user to start the carbon server with -Dsetup in MSSQL server. With lesser privileges, I'm getting the following error. java.lang.Exception: Error occurred while executing : IF NOT EXISTS (SELECT * FROM SYS.OBJECTS WHERE

Re: [Dev] What are the minimum set of SQL server permissions required for registry/um db user?

2014-05-05 Thread Prabath Abeysekera
Hi Charitha, In this particular scenario, it looks like you haven't properly configured the database user being used, with SELECT privileges. Maybe you did, but there's a possibility that it got overridden by some other setting as well. Let me analyse the set of permissions required for SQL

Re: [Dev] What are the minimum set of SQL server permissions required for registry/um db user?

2014-05-05 Thread Prabath Abeysekera
On Tue, May 6, 2014 at 6:44 AM, Prabath Abeysekera praba...@wso2.comwrote: Hi Charitha, In this particular scenario, it looks like you haven't properly configured the database user being used, with SELECT privileges. Maybe you did, but there's a possibility that it got overridden by some