Shared Connections with Non-Shared Personal Credentials

[hmote]

I watched the video tutorials on the forum but had a question about a shared environment. My department shares a server with applications. We would like to setup ASG to share common connections but not share personal credentials. We would also like to use the file option instead of installing the local SQL Server database. Is this possible? If not possible with the file option is there documentation or a video on setting our environment up this way?

[DevOma]

File environment is single user mode - if you want to share connections you should use a database - and of course in database mode you can define "private" or "public" objects - public objects will be available for all users, private objects only for the creator - and private credentials can be only access and decrypted by their owner.

So I think if you want to use it for a team - you should run in database mode - you can use an existing sql server or install a new one

[hmote]

On the database permissions for the credentials and connections. You mentioned private and public objects. Does the ASG application handle these permissions or do we have to login to SQL Server to set these? I would think this would be set in the application and no access to the SQL Server DB would be needed/required. Also, is there documentation on setting all of this up? Thanks again!

[DevOma]

Of course it is handled inside the application - you can activate "Permissions" in Settings - then you can define Security Groups, assign users to these groups, set permissions...

But to access a database your users or a single sql user) needs access to your sql instance/database.

You can find all these information in the help file - you should try to install and use the application - most of it should be easy to use - and if you need some help press F1 on the step where you struggle and if the help file don't help come back and ask in the forum...