Results 1 to 3 of 3

Thread: About Database Design and Rights

  1. #1
    Join Date
    Jan 2021
    Posts
    2

    About Database Design and Rights

    Although little experienced I understand that one can give users different rights of access to the database and tables within. Asume I maintain an application for different departments with equal functionality and their own users. Do I need to use different databases for this or can I arrange it such that rights are granted on different sets of data? Each set distinct and inaccessible for eachother.

    It would be the otherway around to ask if I 'have my own' database when I use an internet service for my financial administration or HRM-data. Or is data from several clients, combined in one database.

    What is the key insight here? And . . . is there difference in for example SQL Server, Oracle, MySQL, etc.?

    Thanks in advance,

    André

  2. #2
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    69
    Short answer...... SQL Server for example..... If you have many users you create GROUPS.

    You modify each Group to have Read Only or Read/Write or Full blown Admin Level access.

    You can adjust different sections of the database for each group as needed.

  3. #3
    Join Date
    Jan 2021
    Posts
    2
    @Steve R Jones

    You write 'You can adjust different sections of the database for each group as needed.'

    Those sections can be records and not tables as a whole?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •