Stack Overflow
Stack Overflow

Questions tagged [sql-revoke]

REVOKE is a standard SQL command to revoke privileges from a user or role in a database system.

The basic structure of the REVOKE statement is:

REVOKE <permission> ON <object> FROM <user-or-role>;

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

28 questions
0
votes
1 answer

Gcloud mysql read only user

I'd like to have a mysql user in GCloud that has only select rigths, i.e. a read only user, for security reasons. For the moment, I have created a user and tried to change its rights with the root account using the following code: REVOKE DROP,DELETE…
NicolasSens
  • 117
  • 1
  • 9
0
votes
1 answer

GRANT/REVOKE execute privileges for an user oracle

How exactly is the GRANT/REVOKE privileges affecting the database. I have a solution ready for a problem where one of my components(an executable) is not identifying my oracle config packages. But is it possible for me to test by revoking with…
user010101
  • 25
  • 9
0
votes
1 answer

Revoke access to a database not applied on mysql active DB Connection

I just want to ask how can I apply grants on active connection ? Currently I'm trying to revoke access to a user for a specific database on active connection and it doesn't work. For exemple if I revoke all privileges to fooUser on database foo, if…
Akram Mo
  • 1
  • 1
0
votes
0 answers

Revoke Modify (INSERT UPDATE Delete Truncate) on a table Cassandra DSE

I have users that I do not want them to truncate from a table in DSE, I used revoke MODIFY on ALL KEYSPACES from USER; I even used Restrict but still, the user can truncate. Is there anything I am missing ? is there any setting in…
Turgut
  • 31
  • 1
  • 1
  • 6
0
votes
0 answers

Postgres tables created on a schema are visible under Public - How can I prevent that?

Been searching to get this answer, but guess keywords on my question are common and search engine returning different answers. I have created a schema with few tables. Why my tables are visible on public Schema? though the tables are not accessible,…
Eyedia Tech
  • 135
  • 1
  • 11
0
votes
1 answer

Revoke the role, bit user still have privilege which he received via role

I have a problem with Revoke command. I created the role and grant to role "SELECTE on table" privilege. Then I grant role to user. Then I revoke role from user. But the user still have "SELECT on table" privilege which he received via role. What I…
Tgy
  • 5
  • 6
0
votes
2 answers

How can I manage stored procedure rights of the role in SQL Server

I want to create three SQL Server database roles. That can CREATE, ALTER and EXECUTE all stored procedures in database That can only EXECUTE all stored procedures in database That have no access to any stored procedures in database I have created…
Yash
  • 356
  • 1
  • 5
  • 22
0
votes
2 answers

Move Tables & Revoke All Privileges

We need users to move their tables from their personal schemas (user_db.username) to the managed schema (userdb.groupname) which provides a predefined set of permissions for select access. In moving the table, we need to accomplish the…
Lee_Str
  • 3,266
  • 2
  • 21
  • 32
0
votes
1 answer

DB2 revoke user privileges from a database from multiple users

I want to revoke all privileges from all users but one from a database. DB2 10.5 LUW I was thinking along the lines of: db2 "revoke all on database from user IN (select grantee from syscat.dbauth where grantee not IN 'SAFEUSER')" but I can't get…
arenginsm na
  • 141
  • 1
  • 8
0
votes
1 answer

Revoke Multiple Users in Oracle Developer

I want to remove a role from a list of users based on a select statement. My select statement works fine, but when I try to implement the revoke statement I get "missing or invalid privilege". I am assuming I'm missing something for the command to…
zeldabluess
  • 27
  • 1
  • 4
0
votes
1 answer

How to revoke alter session privilege in Oracle

I granted the CREATE SESSION privilege to a recently created database user, and I granted him the SELECT privilege on some objects for different database schemas. I find an apps schema (SCHEMA#) in v$session that is different from the database…
Hedi Fourati
  • 31
  • 1
  • 3
0
votes
1 answer

How to restrict a user from executing a COPY query in PostgreSQL?

I need to restrict a user in pgsql from executing copy statement. I can disallow execution of any of the CRUD operations.
user3413804
  • 21
  • 5
-1
votes
1 answer

Postgresql: how to revoke grant option from role?

I have postgresql 15 db. There I have different roles based on which users are created. What I need is to revoke grant option for roles. In my company we need to do it via different system. I tried: REVOKE GRANT OPTION FOR ALL ON SCHEMA schema_name…
Krzysztof Chojnacki
  • 115
  • 4
1
2