Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When providing someone with data connectivity access can you give them access to an entire database or you need to provide access to the database and certain tables only?
@danieldors With respect to Qlik we just connect to SQL databases using appropriate connector. While connecting to Sql database from Qlik we need database user credentials to connect. This user should already have his access profile setup via database access roles which includes the checks like to which database, schema or tables this user can access. So access setup of the user is handled via database management tools which has nothing to do with Qlik. Qlik just sees what that user has access to see
@Kushal_Chawda wrote:@UPSers With respect to Qlik we just connect to SQL databases using appropriate connector. While connecting to Sql database from Qlik we need database user credentials to connect. This user should already have his access profile setup via database access roles which includes the checks like to which database, schema or tables this user can access. So access setup of the user is handled via database management tools which has nothing to do with Qlik. Qlik just sees what that user has access to see
This is an Interesting Blog. Thanks for sharing.
@GraveSparks wrote:
@Kushal_Chawda wrote:
@UPSers With respect to Qlik we just connect to SQL databases using appropriate connector. While connecting to Sql database from Qlik we need database user credentials to connect. This user should already have his access profile setup via database access roles which includes the checks like to which database, schema or tables this user can access. So access setup of the user is handled via database management tools which has nothing to do with Qlik. Qlik just sees what that user has access to see
This is an Interesting Blog. Thanks for sharing.
Yeah it is indeed