1. Gaurav Joshi
  2. Valentina Database ADK
  3. Monday, January 02 2023, 06:44 AM
  4.  Subscribe via email
Hello Everyone,
We have recently started using the Valentina Server and the Valentina Studio.
We wish to understand the following :
1. How to assign user privileges in Valentina Server through the Valentina Studio. I am able to find options to create / drop user or even change password, but unable to find any fields to select the user privileges ( SELECT, INSERT, UPDATE, DELETE, ADD ) through the Valentina Studio ( visually interface). Is it possible to do so through the Studio UI.
2. Is it possible to assign specific user privileges to a specific table in the DB. I understand that its possible to assign user privileges to the DB or Project, but I want to assign different privileges for the same user to different tables in the database.

There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Gaurav,

1. Changing privileges is available only via SQL Editor for Server connection with SQL command (no specific UI).
2. According to the documentation, setting privileges for tables is not supported yet.

We'll discuss it, BUT I don't see any problem implementing it in the nearest versions.
There are no comments made yet.
Scott Accepted Answer
I will second this request. Expanding user privileges at the table level would be very useful.
There are no comments made yet.
Ivan Smahin Accepted Answer
You may use following sql statement to see user privileges:

use master;
show grants;
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Guys,

we have started git-branch with this task.
As only it will be finished we will produce a build with it.
There are no comments made yet.
  • Page :
  • 1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.


Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories