search

wiltondb / wiltondb

RDBMS that can work with applications written for Microsoft SQL Server
https://wiltondb.com
Apache License 2.0
48 stars 1 forks source link

DbReader and DBWriter Role for User Mapping #90

Open JayakumarEMIS opened 1 day ago

JayakumarEMIS commented 1 day ago

Hi @staticlibs, I am trying to create the user for DbReader and DbWriter Roles But I am not able to create in babelfish and getting role does not exist, I referred the documentation for user creation it is mentioned we can only give the access each schema one by one but I want to give only read or write access for particular user which same as sql server, please check and provide solution for it

image

staticlibs commented 1 day ago

@JayakumarEMIS

Please refer to Logins and users wiki page for the supported configurations for logins/users/permissions.

JayakumarEMIS commented 1 day ago

Hi @staticlibs, I referred this page Logins and users using that I can able to create login and user is working fine, but when we we want to give only read or write option for database level is not available, they given one by one for each entities that is not feasible for our need because we have lot tables and views and procedures, so that I tried db reader user mapping but is not exist in babelfish, can you please check and provide the solution

staticlibs commented 1 day ago

@JayakumarEMIS

I think your options are either make a user an owner of this DB or manage per-object fine-grained permissions. I cannot see any other possible options.