Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
2
votes
1 answer

Restrict create table privilege to newly created users in RDS PostgreSQL 9.6

I am facing an issue while creating a readonly users in RDS PostgreSQL 9.6. I am executing the following SQL commands: ---- ###### CREATE ROLE ################ CREATE ROLE readonlyrole_dev; -- Grant access to existing tables GRANT USAGE ON SCHEMA…
Hamid Mahmood
  • 23
  • 4
2
votes
1 answer

Grant Execute Function permission to another user

I have a database function fn_relation_isModerator, only user api has access to this function. Now I want another user to have this permission (while keeping the previous permission as well). I checked routine name and user by following…
Shaharyar
  • 12,254
  • 4
  • 46
  • 66
2
votes
4 answers

Disable all operations (inluding listing with psql -l) on not owned databases for a role?

We are running PostgreSQL 8.3 as the DB server for our ERP system. So far there was no necessity to create different databases under different users (roles in terms of 8.3) in postgres. And now it has appeared. Question 1: Is it correct that a user…
Grigory
  • 992
  • 2
  • 18
  • 34
2
votes
1 answer

SQL Server: permissions to read database diagrams for user that has 'read-only' access

Here I asked what are permissions to read database diagrams: SQL Server: permissions to read database diagrams Suggested answer is "db_owner" role... But in this case user will OWN DB. Is it possible to provide read-only access to DB without…
Budda
  • 18,015
  • 33
  • 124
  • 206
2
votes
2 answers

How to grant UPDATE STATISTICS to any table to a user

According to SQL Server documentation, to run UPDATE STATISTICS ON a table you need the ALTER TABLE permission. I would like my user to have the permission to update stats on any table (current and future). I granted it the database permission to…
MaxiWheat
  • 6,133
  • 6
  • 47
  • 76
2
votes
0 answers

InfluxDB - How can i limit the measures that an user can read by their tags?

I have some data that is collected by several sensors. Some users may own many of this sensors. So, i want to keep all the measures in a single database in InfluxDB. To differentiate the sensors i pretend to add some tags (such as 'sensor_id=aaa',…
David Mendez
  • 157
  • 12
2
votes
5 answers

Prevent SQL Server Table operations (INSERT and DELETE) on some tables

While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked to the "editing", to be able to work…
stckvrflw
  • 1,489
  • 3
  • 22
  • 37
2
votes
1 answer

CakePHP: What to use for MySQL users & permissions?

I'm getting ready to deploy a CakePHP site for the first time. I'm using the site with a MySQL database, and I'm still a little unclear about the proper use of users & permissions for MySQL -- I'm talking about the "login" and "password" fields that…
Steve
  • 129
  • 7
2
votes
3 answers

Cannot Exchange partitions between Oracle schemas. ALTER TABLE EXCHANGE restricted by fine-grained security. Realm violation...EXEMPT ACCESS POLICY

I have a working Oracle procedure that does the following: Chooses a partition from a Source table Inserts records from this partition into a Swap table. (design/structure of Swap table matches Source) Modifies records in the Swap table. Does an…
Steve
  • 541
  • 7
  • 12
2
votes
1 answer

Are there any alternatives to fn_my_permissions when SELECT is denied?

My research has led me to believe that the standard for checking your own permissions in a sql server database is to use fn_my_permissions, but I'm running into a situation where users have somehow lost the SELECT permission on fn_my_permissions,…
user1787270
  • 348
  • 3
  • 10
2
votes
1 answer

SQL Server Deny all users from a table except for one user

Im not too familiar with SQL Server. Can one of you experts please help me with this ! Ive got a table where I want to stop everyone from making changes (Select is fine) except for one user who can read and write to it. So far Ive got the following…
nixgadget
  • 6,983
  • 16
  • 70
  • 103
2
votes
0 answers

CLR Function Permissions Drop About Once A Month

Approximately once a month the production server is dropping permissions on the CLR functions. I have noticed in the logs the permissions drop coincides with the following log entry... 07/10/2013 23:34:27,spid402,Unknown,AppDomain 2…
user2634253
  • 47
  • 6
2
votes
1 answer

Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. in VB.Net

Although I found many posts with this same error, I couldn't find if my error is fixable or not. There is a database which I have read permission with my window login on the network. I just use SSMS to access the table but that isn't really have the…
Laurence
  • 7,633
  • 21
  • 78
  • 129
2
votes
1 answer

implementing Access Control Lists vs using database roles and users

First off before you grill me to the floor, i would like to say i have spent considerable amount of time reading and researching this topic. I have read some on stackoverflow itself such as How can I implement an Access Control List in my Web MVC…
WrathOfZombies
  • 90
  • 1
  • 7
2
votes
1 answer

copy failed: java.io.FileNotFoundException: /data/data/packagename/databases/databasename.sqlite: open: failed: EACCES (Permission denied)

I have a problem with Nuxus 10 with normal user when they install my app and after run....and then it shown error java.lang.Error: Error copying database => java.io.FileNotFoundException: /data/data/packagename/databases/databasename.sqlite: open…
sonida
  • 4,411
  • 1
  • 38
  • 40
1 2 3
…
15 16