Stack Overflow
Stack Overflow

Questions tagged [sql-grant]

GRANT is a standard SQL command that authorizes a set of users to perform a set of operations on an object.

The basic structure of the REVOKE statement is:

GRANT <permissions-list> ON <object> TO <user-or-role-list>
    [WITH GRANT OPTION];

There are various options in standard SQL and most SQL DBMS provide their own extensions to what is specified by the standard.

711 questions
2
votes
2 answers

How to grant UPDATE STATISTICS to any table to a user

According to SQL Server documentation, to run UPDATE STATISTICS ON a table you need the ALTER TABLE permission. I would like my user to have the permission to update stats on any table (current and future). I granted it the database permission to…
MaxiWheat
  • 6,133
  • 6
  • 47
  • 76
2
votes
1 answer

MySQL 5.6 Show ALL Grants for User

I have a MySQL pair that communicates over a VIP. I want to verify permissions for all users (including root) from ANY IP. When I attempt to view all grants for root I get this: mysql> show grants for root; ERROR 1141 (42000): There is no such grant…
Ken J
  • 4,312
  • 12
  • 50
  • 86
2
votes
1 answer

Scope Resolution Operator in SQL SERVER

What is the significance of using Scope Resolution Operator (::) in SQL SERVER. As we all know when we are using GRANT command Scope Resolution Operator will be part of syntax. GRANT ALTER ON Schema :: DBO TO user_name Is there any specific meaning…
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172
2
votes
2 answers

ORA-01720: Can't grant privileges on a view

I have an user with some tables and I granted privileges to three of them to another user. Now I need to create a view and grant select to another user, like this: User A GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE_A TO USER_B WITH GRANT…
Silva_PT_SCP
  • 557
  • 2
  • 8
  • 20
2
votes
2 answers

Why I can create a synonym but no give grant select to the same table?

I am trying to grant access to a table from schema1 to schema2 (oracle10g). I created a synonym on schema2: CREATE SYNONYM schema2.table FOR schema1.table; The synonym was created succesfully. Then I tried to grant select on the same table: grant…
Rodrick
  • 595
  • 10
  • 27
2
votes
1 answer

Grant EXECUTE to many PostGIS functions

I have a Web Application which is based on MapServer, which uses PostGIS as underlying database extension. Now I want to have a dedicated database role which is used for MapServer, cause I don't want to access the database via the postgres…
ilu-tg
  • 23
  • 3
2
votes
2 answers

CMD with icacls issue for windows 10 upgrade - invalid parameters

I'm trying to upgrade my laptop to windows 10 but it says my system reserved partition is low on available size so i'm following microsoft solution on the internet and somehow got stuck with these commands. for your information, i'm stuck on the…
Scorpiorian83
  • 469
  • 1
  • 4
  • 17
2
votes
2 answers

Is it possible to grant insert, update and delete privileges only on temporary tables with MySQL?

I have a user that has only SELECT and CREATE TEMPORARY TABLES privileges on a slave database, to ensure that the slave doesn't get tables changed outside of replication, however without the ability to INSERT (and UPDATE and DELETE) on any temporary…
Ben Holness
  • 2,457
  • 3
  • 28
  • 49
2
votes
1 answer

grant select for temporary table in MySQL

I have a MySQL DB with a user that has access only a few tables. This user has been granted CREATE TEMPORARY TABLES for this database and by watching the query logs, I can see them create a temporary table and then fail while trying to select from…
BCS
  • 75,627
  • 68
  • 187
  • 294
2
votes
2 answers

MySQL granting privileges for a new user removes ability to log in

The issue occurring is MySQL is not letting me create a user then grant its privileges. Following the directions from the site: mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO…
the_basterd
  • 623
  • 1
  • 5
  • 9
2
votes
1 answer

Grant and Revoke on a table in Informix

If I try to execute create table TEST(testColumn VARCHAR(255)); grant insert on TEST to test_user; revoke insert on TEST from test_user; I get the following error message (translated from German by myself): 1) [REVOKE - 0 row(s),…
Chris311
  • 3,794
  • 9
  • 46
  • 80
2
votes
2 answers

unable to grant LOCK TABLES permission to user

I'm running MySQL 5.1.73-0ubuntu0.10.04.1-log and I'm trying to make it so a user can LOCK TABLES. I GRANTed LOCK TABLEs with the following: GRANT SELECT, LOCK TABLES ON *.* TO 'dbuser'; That responds with Query OK, 0 rows affected (0.00…
neubert
  • 15,947
  • 24
  • 120
  • 212
2
votes
1 answer

Does grant ALTER imply grant EXECUTE to a SQL Server stored procedure

I want a database user to have ALTER and EXECUTE permissions to a stored procedure. Do I need to grant those separately, or does granting ALTER allow the user to EXECUTE also? e.g. GRANT ALTER ON [STOREDPROC] TO [SP_USER]; GRANT EXECUTE ON…
Nancy R-I
  • 23
  • 1
  • 5
2
votes
1 answer

mariaDB - error granting rights to users

I have the following users in my database: MariaDB [racktables]> select user from mysql.user; +----------+ | user | +----------+ | admin | | rackuser | | repluser | | root | | root | | root | | | | admin | | rackuser…
dot
  • 14,928
  • 41
  • 110
  • 218
2
votes
3 answers

Are 'rajivratn'@'%' and rajivratn@localhost refer to same user in MySQL?

I want load data into a table (dataset) of a database. I am using the standard command LOAD DATA INFILE '/home/rajivratn/single_output.tsv' IGNORE INTO TABLE dataset ... I am getting the following permission error: ERROR 1045 (28000): Access…
piku
  • 333
  • 1
  • 4
  • 15
1 2 3
…
47 48