Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

SQL Database

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?

 

3 Replies
Kushal_Chawda

@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

GraveSparks
Contributor
Contributor


@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.

wayneoo
Contributor
Contributor


@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