In my last post I described how to create extensions to ArcGis products. After we've finished developing to tools and commands we want to deploy them to our clients.In the development computer, the tools are registered to ArcMap when we compile the project. Now we want our clients to have access to the tools. So how do you do this ? There's a simple checklist of things you need to do in this ESRI article . Follow it and you will create a msi which you can deploy to your clients. Have fun
In our project, we have two users in the database : applicative user and strong user. The strong user is the owner of all the objects (tables,layers,sequences, etc...) and the applicative user has only limited privileges for the object in the strong user. When creating a new database table, you only have to run the grant SQL command on the table to give the access privileges to the app user. When creating a new layer, you just can't only give privileges to the table which represents the layer...