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
0
votes
1 answer

Provide full rw access to one table in MySQL database

I need to give user rights to read a particular DB tables and RW access to one of these. I made commands such as GRANT SELECT ON database.* TO 'someuser'@'somehost'; GRANT SELECT,INSERT,UPDATE,DELETE ON database.rwtable TO…
onkami
  • 8,791
  • 17
  • 90
  • 176
0
votes
2 answers

Granting Table and Index Permissions to another User

User1 grants Select, Delete permissions on a Table(which has index say TableIndex) to a user2. I can see that the user2 is not able to see the index existing on that table though. User2 runs this SQL: select…
Jasper
  • 8,440
  • 31
  • 92
  • 133
0
votes
1 answer

Create MySQL administrative database users in shared hosting package

I have a shared hosting package and MySQL database service. I have some web developers to whom I assign tasks. I want to create a separate database user for each developer. I want to give each database user the permission of create database, so that…
fkabeer
  • 398
  • 4
  • 15
0
votes
1 answer

Granting and Revoking Privileges - MySQL

Say I grant all my privileges to a friend, and he has all my permissions to edit, select, delete, update etc. all my data. Can my friend revoke me from my own database? I believe he can grant my privileges to another person, or many people. Is there…
Dembele
  • 963
  • 4
  • 10
  • 19
0
votes
1 answer

How to restrict queries from specific hosts

How do I make sure 'anil' cannot run commands from any machine called '%desk%'? mysql> show grants for anil; +------------------------------------------------------------------------------------+ | Grants for anil@% …
user1978237
  • 29
  • 3
0
votes
1 answer

Explicit DENY of a GRANT OPTION

In my understanding, in SQL Server, DENY blocks permissions and trumps any GRANTs that are in place. I was just thinking if there is a way to DENY the "with grant option", meaning, prevent any "with grant option" from being given to a principal…
Noble_Bright_Life
  • 569
  • 3
  • 9
  • 16
0
votes
1 answer

select and update grant privilege oracle

I am trying to grant an user privilege to update on specific columns using the where clause. Based on what I have learnt, in order to update using where once must have SELECT privileges. This is what I have and I know the syntax is wrong so could…
user1864262
  • 1
  • 2
0
votes
0 answers

Sybase IQ: Granting a right on tables of one user to anther user

I'm looking for a way to grant some right (say SELECT) on all tables of one user to some other user. Something like that: GRANT SELECT ON Username1.* to Username2 Important condition is that I need not only granting the right to all existing…
ipbd
  • 524
  • 3
  • 16
0
votes
1 answer

Create user in oracle database

I have below requirement in oracle database Create User and grant to all objects in schema "abc" If i add any tables to schema "abc", then the user should have access by default without executing individual Grant Current we are executing Grant…
Prakash Mani
  • 115
  • 1
  • 2
  • 13
0
votes
1 answer

Meaning of Execute_priv on mysql.db table

I created user 'restriceduser' on my mysql server that is 'locked down'. The mysql.user table has a N for all priveledges for that account. The mysql.db table has Y for only Select, Insert, Update, Delete, Create, Drop; all other privileges are N…
Ben Reisner
  • 662
  • 6
  • 16
0
votes
1 answer

How to grant access to the user '\ASPNET'?

I have WinXP Pro 32-bit. I want to run a free trial for a web-based application. The app uses IIS 5.1 and MS SQL Server 2008 R2 (which is SQLEXPRESS). All of these are entirely on my own, single-user laptop. When I type the following, I get an…
OldGrantonian
  • 597
  • 1
  • 8
  • 23
0
votes
1 answer

Deny Error SQL 1142

I have installed 4 phpbb3 forums ru in my server in same SQL database but in separate databases inside. And i want share phpbb_Users table! I follow the steps dcz wrote in:…
LViieira
  • 1
  • 1
0
votes
1 answer

Restore database with changed privileges

We have two PostgreSQL servers. On web server1 pguser1 is the associated user who creates all database objects required to work with the web application. Let's say, all objects are in schema1. Similarly, on server2 pguser2 creates data for Web…
rockbala
  • 2,323
  • 5
  • 20
  • 16
0
votes
1 answer

How to access external database table in MySQL

I have two MySQL databases in 2 different hosts. I would like to from MySQL A table 1 to connect and retrieve data from MySQL B table 2. I do not know which one should set up privilege in order to connecting both each other. I keep receiving: SELECT…
PGoldHow
  • 139
  • 4
  • 16
0
votes
2 answers

GRANT Database Permissions for specific tables and the validity of this as a security practice?

my question is rather simple. Can i grant permissions on a database table wise? something in the lines: User Management has permission to select, update, insert and delete on table Projects User Supervisor has permission to select, update, insert…
Jonathan DS
  • 2,050
  • 5
  • 25
  • 48
1 2 3
…
47 48