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

Altering view/access permissions for a schema in DB2

I am working around a workaround to a "feature" in IBM DB2. This fancy database has a "feature" in it which if I try to use a CREATE TABLE statement and it doesn't find the schema, it will create this schema for me, even if I don't want it to. This…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
-1
votes
1 answer

Grant Privileges and Create Public Synonym in Oracle

I have Views in Schema A and I want to create a Synonym for these views in Schema B. Could you please help me write a query for Granting the role and creating a synonym?
SitGeek
  • 35
  • 1
  • 3
  • 8
-1
votes
1 answer

How to specify the database name in GRANT command?

While the current connection is made to db1, I want to change privileges on db2. Like: GRANT ALL PRIVILEGES ON SCHEMA "db2"."public" TO "user"; But this results in error, and PostgreSQL does not recognize the database qualifier in the statement! Is…
Mehran
  • 15,593
  • 27
  • 122
  • 221
-1
votes
2 answers

How to give the privilege of giving privileges in Oracle

I want to create an application about one user select other users and define there privileges, but this user don't be a Administrator or "dba". A sentence as: GRANT GRANT TO BIG_USER; The "Big User" have many privileges, another users the same or…
Juan C
  • 1
-1
votes
2 answers

Oracle - grant privileges to a user

Is there a way to grant privileges of select, insert, update and delete to a user so that if we add a new table later, the user still have these privileges on the new table ? Thanks for help,
kkung
  • 715
  • 4
  • 10
  • 18
-1
votes
1 answer

Granting "GRANT" privilege in Oracle for a specific role with a specific and limited power

Suppose you have an Oracle user "A" that needs EXECUTE privilege on a set of packages. From time to time, a different user "B" creates a new package that needs to be executable by "A". As such, and as part of the package creation process, "B" must…
FDavidov
  • 3,505
  • 6
  • 23
  • 59
-1
votes
1 answer

SP Grant Execute

I have a new role, which should have permission to execute list of SP and select some Views. I run grant execute/select to role on . Do I need to grant this role select permission to the table used in SP/Views taking in hand that those…
laggerok19
  • 426
  • 8
  • 16
-1
votes
1 answer

What priviliges to GRANT (SQL) for this code (test assignment)

UPDATE Application SET Accepted='YES' WHERE stID IN (SELECT stID FROM Student WHERE Grades>3.9); So the question is what priviliges to grant a user that needs to successfully run this code. My guess is: UPDATE permission on Application, SELECT on…
user3809685
  • 1
  • 1
-1
votes
1 answer

SQL with grant option restriction

Give permission to user 206 to read and modify the faculty and class tables. This user can authorize others to read and modify class but not faculty. For the first part to the questions I have: GRANT SELECT, INSERT, DELETE, UPDATE ON …
user2957877
  • 1
-1
votes
1 answer

MySql - calling select about other database than store procedure user

I have a set of databases under a unique db user which can do select statement over every table of all databases. But now I can't define a store procedure that can do a select statement over other database table. For example I could have a 'joe'…
willypuzzle
  • 321
  • 1
  • 3
  • 10
-1
votes
2 answers

Grant privileges on database to a user

I want to grant select privilege to a particular user in Oracle. Its possible in mysql with following query GRANT SELECT, INSERT, DELETE ON database TO username@'localhost' IDENTIFIED BY 'password'; Is there any way we can achieve this in…
chetan
  • 1,385
  • 4
  • 15
  • 31
-2
votes
1 answer

How can I grant each employee read-only access to their own data?

I have a table called Employee (with columns like name, ssn, age, etc..) Suppose you wanted to give each employee read-­only access to his/her own personal row [the data describing them in the Employee table]. How exactly this might be achieved?
Ryan
  • 5,456
  • 25
  • 71
  • 129
-2
votes
0 answers

MySql Connection Error To Server AlmaLinux

I'm trying to connect to A MySQL database in order to use it for asp.net project in c#. I'm getting error 40 on SSMS which means I inserted the wrong server name or the MySQL server doesn't allow remote connections. Error from mysql…
Andrea Costa
  • 1
  • 1
-2
votes
1 answer

How to block "Select *" but at the same time SELECT/READ permissions should be granted though in PostgreSQL

I am not a database expert nor a fullstack developer. I Have a database in PostgreSQL, where I need to give the database access towards the developers in read only mode, but still if I grant them the SELECT/READ Only permissions, talking in a…
Arjun Balan
  • 43
  • 5
-2
votes
1 answer

GRANT FOR CREATE MASTER KEY ENCRYPTION

When I perform this command: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'mypassword' I get the error: [Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to perform this action. Have any GRANT that I need take for this…
Eduardo de Santana
  • 611
  • 8
  • 14
1 2 3
…
47
48