Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
0
votes
1 answer

Update statement with nontouchable field

I have mssql2008 r2 sql server The problem: User has some column permissions on the table. He could update some of the columns of the table (not all). We need to create UPDATE statement so that it will not violate permissions. Preferably without…
Yuriy Vikulov
  • 2,469
  • 5
  • 25
  • 32
0
votes
0 answers

How to set permissions to refer to multiple databases in a single query (SQL Server)

I have two databases on the same SQL Server, and they have the same table structure. Database2010 is populated with data and Database2007 is empty. I need to write a SQL statement that will copy the data from a table in Database2010 and insert it…
sXe
  • 242
  • 1
  • 4
  • 11
0
votes
0 answers

How to read-only user in postgresql for existing schemas and future new schemas?

I am using postgresql database. I need a new user who can only read from database. I have searched for creating new user with read only permissions. But all of them are for specific schemas. How can i manage database such that if new schema is added…
stackuser
  • 57
  • 4
0
votes
2 answers

master user of AWS RDS does not have privileges to import data, nor to grant the required privileges

I have made a new AWS RDS MySQL instance and I want to import some existing .sql data generated from an existing database using MySQL Workbench's export tool. I connected to the database using the "admin" master user, then started the…
Nathan Tew
  • 432
  • 1
  • 5
  • 21
0
votes
2 answers

Is there a way to make MS SQL Server visible and accessible by a single application?

I have 4 MS SQL Server databases that are accessed by 2 different applications on 2 different computers. The applications work with MS SQL Server as the host of the databases. How do l ensure that when the system is installed, the clients cannot see…
Developer
  • 1
0
votes
1 answer

How to manage user/permissions in an environment web/PL/SQL correctly?

My team will develop an internal (known users) application that has an architecture based on Java as front-end and PL/SQL as back-end. So, currently we are thinking in a better solution to manage the user/permissions, and we have two options: Each…
irobson
  • 825
  • 8
  • 20
0
votes
1 answer

I granted all privileges to a table to a user, but still get "permission denied"

I created a role read_role via pgAdmin: CREATE ROLE read_role WITH NOLOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; and gave it permissions on my schema alter default privileges in schema intgr grant SELECT on tables to read_role…
Sultan Zhumatayev
  • 535
  • 1
  • 9
  • 18
0
votes
1 answer

Postgres 13 - default privileges NOT working

I have a schema "test_db" and a role "test_user" and I'd like to strip DELETE privilege from "test_user" on all tables in the schema "test_db" - how to achieve this? If possible I'd like to not resort to triggers / rules. What I tried so far is to…
zizu_zaza
  • 95
  • 1
  • 8
0
votes
1 answer

Snowflake - Grant permissions by username

I'm trying to restrict read permissions on some entities to a specific user. In Oracle I'd simply do GRANT SELECT ON sensitive_schema.my_table1 TO error_2646; GRANT SELECT ON sensitive_schema.my_table2 TO error_2646; GRANT SELECT ON…
Error_2646
  • 2,555
  • 1
  • 10
  • 22
0
votes
1 answer

classic asp recordset permissions problem

I'm trying to return values of a specific column using the below sql string, If I change it out to sql = "select * from a_page" and objRS("P_description") it returns the values but for some reason my page will not load when using the below…
kurupt_89
  • 1,542
  • 8
  • 37
  • 65
0
votes
1 answer

Deny access to the user to alter any table or relationship in sql server

how to deny acces to a specific user in the database to alter any tables or columns or relationships on a sql server database. is it possible, if we deny alter access of 'schema' to the user does it mean that the user is denied alter access all…
iims
  • 313
  • 1
  • 5
  • 12
0
votes
1 answer

Postrgres : overload the inheritance of a group rigths

I would like to know if it's possible under Postgres for a role to inherit the rights of a group while removing the DELETE right from it.
Dieg13
  • 3
  • 1
0
votes
1 answer

Cannot create database scoped credential with a login that is part of an AD group

I'm trying to find the minimum required permission or role that would allow a user that was assigned permissiosn through an AD group in Azure SQL server to create a database scoped credential via the following syntax. CREATE DATABASE SCOPED…
Geekn
  • 2,650
  • 5
  • 40
  • 80
0
votes
1 answer

Database Connection error using sql server and codeigniter in IIS

Error to connect MSSQL database through PHP I can't able to connect to sql server database in remote system. It is showing Unable to connect to your database server using the provided settings. Filename: returns the bellow error.. Array ( [0] =>…
Diamond
  • 117
  • 1
  • 9
0
votes
3 answers

Oracle SQL Developer accessing SYS packages with a different schema

Using Oracle SQL Developer I'm trying to access a given package that has been created by SYS and in which the, say, FOO schema has EXECUTE and DEBUG permissions, in fact executing a desc will produce the following output: desc…
Nano Taboada
  • 4,148
  • 11
  • 61
  • 89
1 2 3
…
15 16