permissions's questions - English 1answer

1.066 permissions questions.

The DB have a replication server, i need to revoke the permission on the user "user_bi" but allow the acess of this same user on the replication server! REVOKE ALL ON ALL TABLES IN SCHEMA public FROM ...

I'm new to MySQL, moving from MS SQL Server, and I'm wondering if there's a way to logically group tables, views, sp's, etc in the same manner as you would with schemas in SQL Server....seeing as how ...

We expect transaction flow from till to SQL Server (the middleware transportation software is mulesoft), but all of sudden Mulesoft account permissions revoked, we need have to re-generate access to ...

I assume that SELECT HAS_DBACCESS('database name') is equivalent to SELECT HAS_PERMS_BY_NAME('database name', 'DATABASE', 'permission name') for some permission (or set of permissions, the results ...

I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables - the ...

I have a user on a SQL Server that is used for executing SSRS queries. This user was made a sysadmin before I started at this job. I want to remove the sysadmin permission, but not break any reports. ...

I want to create a user in the postgres database which has read access to a particular schema in the database. how can I create that? eg:- if in case a database has 3 schemas public, test and test2. ...

I have a MySQL user with database-level privileges. GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON mydb.* TO 'theuser'; The user can create tables and insert rows into them. When the user ...

Environment SQL Server 2012 (11.0.2100.60) Situation user is allowed to execute a number of stored procedure; user is readonly denywrite one of stored procedure has an EXECUTE statement; The ...

What permissions should I use for Active Directory groups to be able to deploy and then run/schedule their own jobs only? For example, I have 3 folders in the Integration Services catalog. Dept_A, ...

I tried creating a user with all privileges but I am getting this error: Microsoft SQL Server Management Studio Create failed for User 'Hru'. (Microsoft.SqlServer.Smo) Additional ...

I'm trying to grant the NT Service\SQLSERVERAGENT Windows account file system access, based on the marked answer in this question. I believe it's a virtual service account, and it does not show up in ...

I need export all of a MySQL database users (including permissions) for a migration. There is over 5,000 users, what is the best way to do this? Should I just dump the mysql.user table?

I've just discovered that I can create a user and grant right to it on a given database even if that DB doesn't exist yet (it will be created in a second step). MariaDB [(none)]> CREATE USER foo2@...

I've created stored procedures on a (remote hosted - DreamHost) MySQL Database using the HeidiSQL client. One problem i seem to have is that viewing/editing the content of stored procedures is only ...

I get the error message displayed in Power BI Online when using an enterprise gateway connected to an on-premise SQL Server Unable to connect: We encountered an error while trying to connect. ...

In PostgreSQL 10 - when using an "owner user" (login role owning a schema and all tables, not used by the application at runtime) and a "runtime" user I can GRANT Select/Update/Delete permissions on ...

I have 2 users are present in oracle ex User1 and User2, Under user1 some tables are present ex t1,t2,t3 etc.. . what are the minimum permissions to view the tables of user1 by using user2 ( Just want ...

I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like to prevent ALTER commands on master to replicate (such as CREATE, ALTER, DROP...) whatever ...

I was given this view that when I query it using OracleSQLDeveloper it returns nothing, but if I use Toad it does return records! I cannot inspect the definition of the view, and no errors are ...

I have a exe file that read and write from local Db file. I check this file with Detect It Easy and it tell me that is mdb file. I can open this file with Microsoft Access, and watch all the tables ...

I have a pretty standard problem that I can't resolve. I want to remove a user in redshift DROP USER u_A; which returns me: user "u_A" cannot be dropped because the user has a privilege on some object....

We have a web application that allows users to modify data through an API. In order to allow people to run tests, we provide a sandbox area called 'daily'. This sandbox gets refreshed every day from ...

I have two IPs (192.168.13.1 and 192.168.13.2) in my Server A and have provided select access to another Server B for secondary IP/virtual IP (192.168.13.2). mysql> show grants for web_app@192....

I'm using SQL Server 2016 for these tests. The following did not allow me to create a table in schema S for user U USE [D]; GRANT CONTROL ON SCHEMA :: [S] TO [U]; But this did: USE [D] GRANT ALTER ...

I have created a database and have my username which is part of the rds_superuser group. I granted a friend access to my database and whenever he creates a new table I am unable to view his table and ...

We're managing about 200 instances of postgres on Amazon RDS. The problem that we're constantly experiencing is that our "DBA" accounts can't access stuff. Basic stuff. Tables, views, etc. Is there ...

I have a user "sa" which is sysadmin in a MSSQL instance. All users who log into the database have the permission to change the password and delete the "sa" user. Is there a way to revoke this ...

I'm trying to obtain a list of users associated with the AD Groups represented by the logons in my database. I understand from my research that the best way to do it is using this code: { Server ...

I'm structuring a RBAC in a Web system. My database tables looks like: actions id name resources id name permissions id action_id resource_id roles id name permission_role permission_id ...

[I think the root cause of this problem is me not understanding permissions and privileges...] So, to set the stage, the set up I have is a DB, call it MyDb. I have two users, spu1 and u1, spu1 is a ...

Modifying the Active Directory group membership for a particular user propagates to our SQL Server instances as expected — except when one specific group is added. What is causing this issue, ...

A have a live/production CentOS 6.8 server with Nginx, PHP (multiple versions), MySQL 5.7.18 and latest (when writing this question) phpMyAdmin 4.7.0. This server is running for many years and with ...

I have an AD group that is setup as a Windows Authenticated SQL Login on my SQL Server. On DatabaseA it has the db_datareader and public roles. So the users of this AD group only have read access to ...

Create or replace procedure myprocedure is stmt varchar2(1000); stmt2 varchar2(1000); begin stmt := 'create global temporary table temp(id number(10))'; execute immediate stmt; ...

I'm having some friction when it comes to showplan permission security. Say there are 5 databases on a server. And each one has a test/ production split (so 10 total). There is one sysadmin. There ...

I run following commands: CREATE USER 'dbuser'@'%' IDENTIFIED BY PASSWORD('mypass'); CREATE USER 'dbuserx'@'%' IDENTIFIED BY PASSWORD('mypass'); SET PASSWORD FOR 'dbuser'@'%' = PASSWORD('mypass'); ...

I have a new Master/Slave config running. Everything is happily replication. I have added a secondary user whose role will be to manage the databases and tables. Currently the following privileges ...

If I create a new database cluster (via initdb), then create a new database. How are the "default privileges" and "global default privileges" implemented? For example, when I run \ddp in psql, it ...

Let's say I grant a privilege to "user_a", "user_b", "user_c". Is it possible to REVOKE from all users in previous grants, but without specifying them explicitly? Something like this: REVOKE ALL ...

I have a user in a SQL Server 2014 database that only has permissions to insert into a table (no select permissions). When change tracking is enabled on the table, the inserts will fail with The ...

The Problem I am trying to setup Hashicorp vault and Postgres in Google Cloud. I am using liquibase to manage the schema and when that does a migration, it retrieves a username/password from vault ...

Question: I have a SQL Server 2005 server and a SQL Server 2016 server. On each server is a database (A) with a stored procedure that selects data from a view in Database (A) The view in database (A) ...

My ultimate goal is to allow administration for the purposes of password resets with minimal possible permissions given. It seems to me that with the UserAdmin role, or even UserAdmin with ...

I'm building an application that is attached to a legacy application database. The application has it's own database that is on the same server as the legacy database. My application is ASP.NET and ...

I'm currently attempting to define a new user using the following: mysql> GRANT ALL PRIVILEGES ON simple_cms_development.* TO 'br'@'localhost' IDENTIFIED BY 'password'; However, it is ...

I'm using postgresql on two machines, and I regularly create a dump on the production server and restore it on my development computer. Usernames are identical. The dump / restore porcess works in ...

I'm not very familiar with Oracle SQL at all, but using our admin account I ran the following query on our Oracle database server: GRANT SELECT ON Table1 TO OtherUser. I then committed this change (...

I have to copy the entire database permissions from database A to database B which has same objects in database B in same instance. What are the things that I need to copy from database A to ...

I have a little trouble with SQL Agent Job. It should execute program in network directory like \\x\y\z.exe. Job Step uses proxy account with credentials of a user, which can full access that ...

Related tags

Hot questions

Language

Popular Tags