1. Gaurav Joshi
  2. Valentina Database ADK
  3. Montag, Januar 02 2023, 06:44 AM
  4.  Abonnieren via E-Mail
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.

Regards,
Gaurav
Kommentar
There are no comments made yet.
Gaurav Joshi Akzeptierte Antwort
Hey Ruslan,

Thats really great.

You provided the feature so soon.

Really appreciate.

Regards,
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Gaurav,
Hi Scott,

Please notice the post about the 13b10 upload on this forum.

Below URL to the wiki page, which contains info about GRANT PRIVILEGES
Referenzen
  1. https://valentina-db.com/docs/dokuwiki/v13/doku.php?id=valentina:vcomponents:vsql:reference:grant_privileges#examples
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
Hi Guys,

we have started git-branch with this task.
As only it will be finished we will produce a build with it.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
You may use following sql statement to see user privileges:


use master;
show grants;
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
I will second this request. Expanding user privileges at the table level would be very useful.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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