Sprinkle Docs
  • What is Sprinkle?
  • Quick Start
  • Analysing your data
    • 🔭Analytics Overview
    • 💠Data Models
      • *️Variables
      • 🌲Hierarchies
      • 🤿Column Mask
    • 🎉Switch to New Reports & Dashboards
    • 🆕Reports
      • Overview
      • Build Using Tables
        • Create a new Report
        • Layout and options
        • Build and Format - Overview
        • Apply Row Limits
        • Identify Date Columns
        • Filter your data
        • Visualizations
          • Table
          • Pivot
          • Line Chart
          • Bar Chart
          • Column Chart
          • Area Chart
          • Combo Chart
          • Scatter & Bubble Plot
          • Pie Chart
          • Funnel Chart
          • Stat Card
          • Point Map
          • Heat Map
          • Radial gauge chart
        • Advanced Features
          • Custom Analysis
          • Variables
          • Table & Quick Calculations
          • Drill - Hierarchical & Date
          • Break Out
          • RLS in Table reports
          • Scheduled Exports
          • Embedding Table Reports
      • Build Using Models
        • Create a new report
        • Layout and options
        • Visualizations
        • Advanced Features
      • Build SQL Reports
        • Create a new Report
        • Layout and options
        • Writing a SQL Code on Editor
        • Visualizations
        • Variables in SQL Reports
    • 🆕Dashboards
      • 🌀Filters
      • 👆Click Behaviour
      • ⏰Data Alerts
      • 🗓️Date Drill
      • 📤Scheduled Exports
      • 🔗Embed link
      • 🖥️Dashboard layout
      • 📱Mobile Dashboards
  • Transforming your data
    • 🔰SQL Transform
    • 📓Python Notebooks
  • Integrating your data
    • ☁️Destination Warehouses
      • AWS Athena
        • Manage storage of Flow tables
      • AWS Redshift
      • Azure Synapse
      • Databricks
      • Google BigQuery
      • MySQL
      • Postgres
      • Snowflake
      • SQL Server
      • K8 Setup
        • AWS EKS
        • Google GKE
        • Azure AKS
    • ⚙️Warehouse & Storage Setup
  • Ingesting your data
    • ☄️Data Imports
      • Databases
        • Azure Cosmos DB
        • Azure Table Storage
        • Google BigQuery
        • Mongo DB
        • MySQL DB
        • Oracle DB
        • Postgres DB
        • SQL Server DB
        • Features
          • Ingestion Modes
          • Add Multiple Datasets
          • CDC Setup
            • CDC setup in Mysql
            • CDC setup in Postgres
            • CDC setup in Mongo
            • CDC setup in SQL Server
          • Destination Create Table Clause
          • SSH Tunnel Setup
      • Files
        • AWS S3
        • AWS S3 External
        • Azure Blob
        • FTP
        • Google Cloud Storage
        • Google Sheet
        • SFTP
      • Applications
        • Apple Search Ads
        • Appsflyer
        • Branch
        • Clevertap
        • Facebook Ads
        • Freshdesk
        • Freshsales
        • Google Ads
        • Google Ads V2
        • Google Analytics
        • Google Analytics 4
        • Google Analytics MCF
        • Google Search Console
        • Hubspot
        • Impact Ads
        • Intercom
        • Klaviyo
        • Leadsquared
        • LinkedIn Ads
        • Magento
        • Mailchimp
        • Marketo
        • Mixpanel
        • MoEngage
        • Rocketlane
        • Salesforce
        • SAP S4
        • Shopify
        • Snapchat Marketing
        • TikTok Ads
        • WooCommerce
        • Zendesk Chat
        • Zendesk Support
        • Zoho Analytics
        • Zoho Books
        • Zoho CRM
        • Zoho Desk
        • Zoho Invoice
        • Zoho Subscription
      • Events
        • Apache Kafka
        • AWS Kinesis
        • Azure EventHub
    • 📤File Uploads
    • 🤖API Pulls
    • 🕸️Webhooks
  • Collaborating on data
    • 📤Sharing
    • 💬Comments
    • ⚡Activity
    • 🏷️Labels
  • Managing Schedules and Data Refreshes
    • ⏱️Schedules
    • 🔔Notifications
  • User Management
    • 🔑Access Management
    • 🧑‍🤝‍🧑Groups
    • 📂Folders
    • 🔄Syncing users, groups and RLS
    • 📧Azure AD Integration
  • Data Security & Privacy
    • 🔐Security at Sprinkle
    • 📄GDPR
    • 📄Privacy Policy
  • Release Notes
    • 📢Release Notes
      • 🗒️Release Notes - v12.1 (New)
      • 🗒️Release Notes - v12.0
      • 🗒️Release Notes - v11.0
      • 🗒️Release Notes - v10.8
      • 🗒️Release Notes - v10.7
      • 🗒️Release Notes - v10.6
      • 🗒️Release Notes - v10.5
      • 🗒️Release Notes - v10.4
      • 🗒️Release Notes - v10.3
      • 🗒️Release Notes - v10.2
      • 🗒️Release Notes - v10.1
      • 🗒️Release Notes - v10.0
      • 🗒️Release Notes - v9.31
      • 🗒️Release Notes - v9.30
      • 🗒️Release Notes - v9.29
      • 🗒️Release Notes - v9.28
      • 🗒️Release Notes - v9.27
      • 🗒️Release Notes - v9.25
      • 🗒️Release Notes - v9.24
      • 🗒️Release Notes - v9.23
      • 🗒️Release Notes - v9.22
      • 🗒️Release Notes - v9.21
      • 🗒️Release Notes - v9.20
      • 🗒️Release Notes - v9.19
      • 🗒️Release Notes - v9.18
      • 🗒️Release Notes - v9.17
      • 🗒️Release Notes - v9.16
      • 🗒️Release Notes - v9.14
      • 🗒️Release Notes - v9.13
      • 🗒️Release Notes - v9.12
      • 🗒️Release Notes -v9.8
      • 🗒️Release Notes - v9.7
      • 🗒️Release Notes - v9.6
      • 🗒️Release Notes - v9.5
      • 🗒️Release Notes - v9.4
      • 🗒️Release Notes - v9.3
      • 🗒️Release Notes - v9.2
      • 🗒️Release Notes - v9.1
      • 🗒️Release Notes - v9.0 (Major)
      • 🗒️Release Notes - v7.23
      • 🗒️Release Notes - v7.21
      • 🗒️Release Notes - v7.20
      • 🗒️Release Notes - v7.15
      • 🗒️Release Notes - v7.14
      • 🗒️Release Notes - v7.13
Powered by GitBook
  1. User Management

Access Management

PreviousNotificationsNextGroups

Last updated 9 months ago

Access Management is the go-to place for all users, access, and permissions-related settings. It deals with the complete life-cycle of the users on the platform, from inviting users, adding them to groups, and configuring their roles and permissions to deactivation. Access Management lets the admin be in control of the users and their activities on the platform.

Watch Video

It has the following sections: Users, Groups, Folders, Row Level Security, Access Request & Uploads.

Users

This section provides an overview of all the users from the organization along with their type and status on the Sprinkle platform.

Standard: Users who have permissions apart from the view permissions as a part of the groups they are assigned to.

Invite Users

Click on the Invite User button, to invite new users to Sprinkle. Provide the Email Id of the invitee and select the group to assign the new user to. Enable the bottom toggle switch to make the user a Viewer.

Invited: The users invited on the platform are added to the user list with their status as Invited until they onboard the platform.

Registered: Users who have successfully onboarded on the platform.

Inactive: Admins can deactivate users from the platform

Blocked: Users with more than 3 unsuccessful login attempts are Blocked to access the platform. Admins can unblock users using the Reset button in the Actions column.

Actions

Make User Viewer: Clicking on this icon corresponding to the user would make the user a viewer.

Reset Failed Login Attempts: After 3 unsuccessful login attempts by the user, this icon link gets activated. Admin can click on it to reset the failed login attempts count and the user can try logging in again.

More Options

User Actions: This feature enables the Admin to take automated actions. The two automated actions currently supported are, Deactivating the users, not in Azure AD and Email for Inactive Users.

Groups

Managing, assigning & adjusting various permissions for a huge number of users can be a tedious task. Use groups to efficiently manage access of similar kinds of users.

To quickly get you started with managing the accessibility, Sprinkle has default groups created.

Default Groups

To learn in detail about the Groups, visit the below page.

Row-Level Security

Navigate to Admin -> Access Management.

User Types

Viewer: Users who only have view permissions on the data entities in Sprinkle. Know more .

User Status

Upload User Keys: Admin can upload user keys and also set an expiration date. Bulk Invite: Through this feature, Admins can invite users to Sprinkle by uploading User details.

Bulk Invite: Invite users in bulk by uploading files with user email.

Download Users: The list of users currently on Sprinkle along with their status can also be downloaded as a CSV file.

Deactivate users not in Azure AD: When someone leaves your organization or is removed from Azure AD, those users can get deactivated on sprinkle automatically, using this feature. Read more .

Email for Inactive Users: Using this feature Admin can schedule emails to the Inactive users.

Administrator

Data Team

Business Team

Viewers

API_Access Grp

Folders

Folders can also be referred to as Spaces, these spaces may be user-specific, all folders or shared folders for a certain group of users. Managing access to reports for a group of users can also be done using the folders functionality. Read more about folders .

Row Level Security lets you manage the row-level access of the models. It lets you restrict users to access only the relevant part of the table. For example, you can restrict users in Karnataka to access the sales data only relevant to Karnataka from the sales table. Read more about Row-level Security .

Uploads

If there are a large number of users and their permissions are maintained within your own database, you can map those users and permissions in Sprinkle automatically. Sprinkle has an upload service, for uploading user keys and user attributes. If the user has user keys and/or user attributes in their data sources and these are frequently updated, then the user can make use of this service to schedule them. Read about the procedure to sync users .

🔑
🖱️
💡
💡
🗝️
⬆️
📥
✉️
🛡️
👩‍💻
👨‍💻
👨‍💼
👩‍💼
👀
🤖
📂
⬆️
here
🧑‍🤝‍🧑Groups
here
here
📺
Groups tab on Access Management page
here
here
Access Management : Explanations & Feature Walkthrough