Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35942

Update privilege is not enough for update

    XMLWordPrintable

Details

    Description

      I receive error
      SELECT command denied to user '...' for column '...' in table '...'
      while trying to execute UPDATE command on modifiable view with UPDATE privilege granted. I found that execution gets error unless SELECT privilege is granted. In Oracle database I can have only UPDATE privilege and it's enough for command to complete. Is that designed behavior? Is there any system parameter to avoid assigning SELECT privilege along with UPDATE to keep current privileges?

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.