Ability to lock Alteryx Databases

[chris72712]

Hello,

I work with alteryx databases a lot to store some historical data so I don't have to pull it in the future. It would be great if there was a way when creating the database, where I could lock them for editing and can only be edited by select usernames and passwords.

Thanks,

Chris

[Mstead]

Hey Chris,
You can try putting the data in a SQL Server (or other database tool) and use credentials in there to ensure you can only have certain people read/write to the database from there. Alternatively, you can place the alteryx database in a file location where only certain users have access to and run a workflow that is encryped with those same people's accounts.

[MarqueeCrew]

@chris72712,

The yxdb files can be written to a directory that only allows for read privileges to the public.  Another work around is to use the command line tools in windows to limit access.

https://technet.microsoft.com/en-us/library/2009.07.geekofalltrades.aspx

If you write the file(s) to a cydb, you can provide a license key that provides other forms of access controls.  Just a few interim ideas.

Cheers,

Mark

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!