Save scripts in the workspace per user

[valentintraen]

Hi !

Several of the CloudBeaver users at my company are web developers. They therefore need to regularly purge cookies from their browser and lose their tabs.

It would be great if they could save their sql scripts in the application workspace and not in the browser, and that everyone could only see the scripts they created (a bit like the tabs currently).

[EvgeniaBzzz]

Hi @valentintraen
If I understood you correctly, your developers were simply writing and using scripts without saving them.

The script save button can be found in the left toolbar of the SQL editor, it looks like an old-school 3.5-inch floppy disk. After clicking it, a pop-up will appear where you can change the script name. Scripts created for private connections are visible only to their creators. Saved scripts are available in the side panel on the right (upper toolbar: Tools → Show scripts).

This article about the Resource Manager might also be helpful.

It that's not your case, please provide more information.

[valentintraen]

I had seen this option but it only seems available on administrator accounts, right? I have it but the developer accounts don't have it

[EvgeniaBzzz]

Could you describe your configuration? What permissions do your developers have? Common users? Are they using the connections you created in the shared project?

Please check that the Enable resource manager option is enabled in the server configuration. All users have access to creating scripts if this setting is enabled.

[valentintraen]

Resource manager is already enabled.
All the devs belong to this ldap group mapping :

My account is mapped the same way but with admin rights

[EvgeniaBzzz]

Are they definitely logging into the application under their own user accounts? With the Resource Manager enabled, the only reason I can think of for not being able to save a script is if the user is anonymous (not logged in).

[valentintraen]

Yes, it is certain that they get along well with their user, we cannot do otherwise. And I tested it myself with a test user who is in their group, and indeed, I cannot save a script.

[EvgeniaBzzz]

Can you check if that test user can see scripts tab?
Tools → Show scripts

[EvgeniaBzzz]

What version are you using now?

[valentintraen]

Yes, but in read-only :

(I created this script with my own account)

The last version, 25.3.0

[EvgeniaBzzz]

Thank you, we'll need some time to investigate.

[valentintraen]

Yes no problem. It looks like scripts are managed like connection configurations: the admin creates them and gives rights to them. Thank you

[EvgeniaBzzz]

That's because private connections are disabled in the server configuration.
We are planning to add a permission that allows non-admin users to edit shared scripts.

For now, as a workaround, you can enable private connections. This will add the connection creation button, but it will also allow users to save scripts in the local project.