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

Grant Access to a MySQL user by batch-file

I have trying to make GRANT ACCESS to a MySQL Server user. I have wrote following command in mybatch.bat : @echo off cd / c: set mysql_cmd = "GRANT ALL PRIVILEGES ON mydatabase.* TO 'myuser'@'192.168.1.%' IDENTIFIED BY '123abc' WITH GRANT…
Hamed Kamrava
  • 12,359
  • 34
  • 87
  • 125
2
votes
1 answer

How to revoke explain plan privilege in mysql for a user? is it possible

How to revoke explain plan privilege in mysql for a user? is it possible Please help me here.
mithuna kous
  • 309
  • 3
  • 11
2
votes
1 answer

postgreSQL: grant select on all tables in schema FOO to FOOROLE

EDIT: Found it. I thought USAGE was an explanation, not a key word. :-) What else must occur in addition to GRANT SELECT ON ALL TABLES IN SCHEMA FOO to FOOROLE in order for FOOROLE to be able to select from, say, FOO.CUSTOMER? Is there…
Tim
  • 8,669
  • 31
  • 105
  • 183
2
votes
1 answer

Issue inserting data into a mysql table using cloudfoundry's vmc utility

I am having issues with user privileges in mysql and cloudfoundry. I was able to insert data into a table and I am trying to insert data into another table and running into the following issue: mysql> source…
balteo
  • 23,602
  • 63
  • 219
  • 412
2
votes
1 answer

Backup grant privileges for a selected mysql database

I have backup the mysql database db1 from a bunch of database hosted on the same server. Now need to backup only the selected users with privileges who have access to db1 so that I can restore these privileged users to my new server before the db1…
PiyusG
  • 1,157
  • 16
  • 28
2
votes
2 answers

Grant permissions IIS 7 Microsoft windows server 2008

I have a web service which I have deployed on IIS 7. No whenever a client calls web service method, then internal server error(500) is thrown back and we get "The source was not found, but some or all event logs could not be searched. Inaccessible…
user1000258
  • 567
  • 2
  • 8
  • 16
2
votes
1 answer

Grant change password privilege in microsoft access

I have a database built in Microsoft Access and have two users: DBAdmin User DBAdmin is the administrator and has all privileges. User has only the ability to modify entries in all tables and change his/her password. How would I be able to grant…
Ossama Nasser
  • 71
  • 4
1
vote
2 answers

MySQL: GRANT effected 0 rows a bug or by design?

I was successfully able to grant a user limited permissions to a specific database... C:\mysql\>mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. GRANT SELECT, INSERT ON jabcre5_examplecom.* TO…
John
  • 1
  • 13
  • 98
  • 177
1
vote
2 answers

Mysql: How do I GRANT SELECT on a demo database to all users

I have a demo mysql database the I would like all users to be able to see. How do I grant SELECT on this one database to all the mysql users? I tried: GRANT SELECT ON demodb.* TO ''@localhost; This seemed to run, but no change on the visability of…
Tony Collin
  • 13
  • 4
1
vote
1 answer

which privileges should be set for website database user / client in mysql

So what privileges should be set for the mysql user that is to be used as 'main' user for the website? I'm thinking data and structure ( see below ) for the database that is used should be set. But do i need to add administration rights also? And…
FLY
  • 2,379
  • 5
  • 29
  • 40
1
vote
2 answers

Does GRANTPRIVILEGES overwrite an existing user and password?

Does the following command: GRANT ALL PRIVILEGES ON myblog.* TO "wordpress"@"localhost" IDENTIFIED BY "summer"; If executed, set a new password, when there is already an existing user wordpress with password winter?
user1145216
  • 2,434
  • 3
  • 15
  • 14
1
vote
1 answer

How do I create a mysql view with a user variable in the name

I'm using mysql 5.5, trying to write a script to create users, views, and grant select privileges on those views. Here's what I have so far. set @type_id := 1; set @username := 'somecompany'; set @password := 'company1234'; set @prefix :=…
Luke L
  • 83
  • 1
  • 7
1
vote
1 answer

Tomcat Deploy fail in free.hostingjava.it

I am using free.hostingjava.it for my application, but when try to deploy the web app, it gives me an exception: Caused by: java.security.AccessControlException: access denied (java.lang.RuntimePermission…
Edgar Rios
  • 11
  • 1
1
vote
1 answer

how do I execute a 'GRANT SELECT ON' statement using pyodbc

I am working with hundreds of msaccess databases. I am trying to build a summary of databases, tables and other objects. To find out all the tables and objects in a given database, I use the query select * from MSysObjects However, I get the pyodbc…
user671111
  • 41
  • 4
1
vote
2 answers

How to Use subinacl in Installer ? C# Setup Project

I want to grant a permission to my service to user/everyone. I can use subinacl to grant such permissions but am not usre how to code for it in the Installer class ? And also if I want to grant permission to every user on the comp, can I use…
Tvd
  • 4,463
  • 18
  • 79
  • 125
1 2 3
…
47 48