Stack Overflow
Stack Overflow

Questions tagged [database-permissions]

238 questions
0
votes
1 answer

Basic configuration of database permissions

I'm learning databases and I have a question how to prepare the rules and groups configuration for the following assumptions: I have two databases: databaseA databaseB Each database will have several users connecting using the connectionString…
Dan Stiefel
  • 1
0
votes
1 answer

How to let other people in my office access my databse?

I need to share my database from PostgreSQL in my PC with my colleagues in the same office (in the same network). I did some research but I still have some questions regarding it. A bit background for myself: I have been using PostgreSQL…
Gin
  • 129
  • 2
  • 12
0
votes
1 answer

How to lock or revoke permission for Postgres user for temporarily

Can you please tell me how to lock a user in Postgres for temporarily. I have tried different commands but nothing seems to work. REVOKE connect from john. alter user john ACCOUNT lock; please help me. my ph_hba conf file # IPv4 local & remote…
user10801913
  • 11
  • 5
0
votes
1 answer

Creating admin user in PostgreSQL

I am trying to create an admin role/user in PostgreSQL which should fulfil the following requirements: Should be able to do backup for the particular database (and not others) Should be able to create usernames which can access the particular…
shahzad ise
  • 45
  • 2
  • 6
0
votes
0 answers

Redshift Grant Statements Taking a very long time

I am running an SQL script called by workbench/J in CLI to execute about 15 grant statements. This takes well over 30 minutes. The data has not changed, and all other types of statements run at their regular speed. Workbench Build 119
elcunyado
  • 351
  • 1
  • 2
  • 11
0
votes
1 answer

How can I make sure a function only SELECTs from one specific schema?

What do I need to do to make sure that sandbox.execute_any_query() only SELECTs from tables in schema sandbox? create function sandbox.execute_any_query(_query text) returns json as $$ declare _result json; begin execute format('select…
user1602492
0
votes
2 answers

ORACLE query to find all permissions/access for all users in a database

I'm looking for a query listing all the users that have access to a specific database. Hopefully similar to this one but to query Oracle database. SQL Server query to find all permissions/access for all users in a database
Wendy
  • 640
  • 1
  • 4
  • 8
0
votes
2 answers

SqliteOpenHelper for Mode_World_Readable, how?

SqliteOpenHelper by default creates database in mode_private. How can we create world readable/writable db using SqliteOpenHelper ? Or Else Do I need to use Context.openOrCreateDatabase()
ankitjaininfo
  • 11,961
  • 7
  • 52
  • 75
0
votes
1 answer

how to prevent SQL Server users from creating temp tables?

We'd like to prevent users from having the ability to create temp tables on production SQL Servers. It seems that simply being able to login to SQL Server includes permission to create temp tables. How can we revoke this permission without…
Eric B
  • 75
  • 6
0
votes
1 answer

Cannot enable select into/bulkcopy on SQL Server 2005 database using sp_dboption

I am trying to enable the select into/bulkcopy database option on a SQL Server 2005 database using the command: EXEC sp_dboption 'mydbname', 'select into/bulkcopy', 'true' After executing the above, running EXEC sp_dboption 'mydbname', 'select…
Jason Sparks
  • 1,306
  • 11
  • 11
0
votes
1 answer

Allowing a user group to only create objects on schema of own username?

I've been tasked with creating a usergroup where users of a database would be able to create objects, but only under the schemas of their own usernames. As an example user foo\bar would only be able to create objects on the schema 'foo\bar'. Is this…
TheLocalBear
  • 1
  • 1
0
votes
1 answer

PostgreSQL: hide table INSERT UPDATE DELETE behind a function

I understand how to use GRANT to control who can do what to a DB object. I have a case where it would be useful to have specific functions that modify a table's contents while preventing a user from directly accessing the table. Let's say I have a…
IamIC
  • 17,747
  • 20
  • 91
  • 154
0
votes
0 answers

SQL Server limit ALTER permissions

I've implemented a process to import data to a database that needs to set IDENTITY_INSERT ON and OFF. However, to have this permission the user must own the table or have ALTER permission on the table. As changing the process is not possible, my…
Eduardo Poças
  • 19
  • 2
0
votes
3 answers

SQL Server: Grant execute without grant dml

I have a db user that has only db_reader permission. (He has SELECT on everything). I have 100 stored procedures. I want him to have the ability to execute only the SELECT SP and not DML. Unfortunately, granting him 'execute' on all - allows him to…
Faruz
  • 9,909
  • 10
  • 48
  • 66
0
votes
0 answers

Permission error when stored procedure is executing SSIS package as 'sa'

I have a stored procedure that execute an ssis import package, that stored procedure is called by a service broker queue. I get the following error : 'The server principal "sa" is not able to access the database "SSISDB" under the current security…
Vincent Chalmel
  • 590
  • 1
  • 6
  • 28
1 2 3
…
15 16