As of now, datafi only support read operations to datasources like SQL, NoSQL dbs. As a best practice to improve security, we would advice you to create a new user to your DB with read-only access to connect to datafi. Some of the sample options are given bellow, If you need help with creating a read-only user for your DB please reachout to us at [email protected] .
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass'; GRANT SELECT ON ALL TABLES IN SCHEMA public TO youruser;
USE master CREATE LOGIN datafi WITH PASSWORD='$password' --password has to be complex (letters, numbers, signs) USE $database CREATE USER datafi FOR LOGIN datafi ALTER USER datafi WITH DEFAULT_SCHEMA=db_datareader EXEC sp_addrolemember N'db_datareader', N'datafi' EXEC sp_addrolemember N'db_ddladmin', N'datafi' GRANT SELECT ON sys.database_files TO datafi
Updated 6 months ago