Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [authorization]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
20 views

Cyclic Grants in SQL

I wonder what the result of the following grant/revokes is according to the SQL standard. Suppose A created a table tab and there are four users (i.e., A, B, C and D). The SQL commands are: grant ...
anotherme's user avatar
0 votes
0 answers
348 views

Job getting account disabled Error, but works as normal when executed manually

The account used in a linked external SQL Server was disabled, by the external server, temporaly. After the restoration of access, various job routines that used this account continued working, as ...
gabril's user avatar
  • 1
0 votes
3 answers
1k views

Create Sequence Permission for Postgres

When my postgres function is tries to create a new sequence, it returns a permission denied error. It looks like the only way to make it work is to give Create permission on schema using the below ...
Harshit Tekriwal's user avatar
-1 votes
1 answer
122 views

Creating a database with authentication enabled on mongodb

I can create a database using a specific role for my "user1". I have tested and a user "test1" can not create a database in the mode authorization enabled. How works the creation ...
Rodrigo N M's user avatar
0 votes
2 answers
41 views

Operation level authorization in PostgreSQL

I'm developing an analytics application that provides multiple levels of visualization of a data warehouse in a Postgres DB. One of its requirements is that different users should have different ...
Felipe Felix's user avatar
1 vote
0 answers
26 views

Granting privileges on a view

I'm reading Database System Concept, in a chapter about authorization, the book first says that: A user who creates a view does not necessarily receive all privileges on that view. She receives only ...
Kaiyu Yang's user avatar
0 votes
1 answer
2k views

Postgres 13 - Grant to Active Directory Groups?

Is it possible to grant an AD group in PG 13 without sorting to creating the group in the database? Similar to how AD groups can be granted directly in SQL Server. The PG server is on a Windows server ...
geeko's user avatar
  • 31
0 votes
3 answers
3k views

Stored procedure runs fine when executed manually but fails in scheduled job

I have a stored procedure that runs fine when executed manually but fails in scheduled job. The error I receive is: Executed as user: \USER-a. Login failed for user '\USER-a'. [SQLSTATE 28000] (Error ...
user216531's user avatar
0 votes
1 answer
51 views

SQL Server 2017 installation unauthorized error

I'm getting the below errors while installing SQL Server on a Windows machine. I'm using my admin account which has permissions (I’m in Administrations group. Verified here -> Computer management -&...
Jetr_forever's user avatar
1 vote
1 answer
2k views

How to access Multiple DB2 Relational Databases In A Single Query

I am looking for a solution to the problem described below. There are two DB2 instances with two authorization IDs on the same server and can be accessed using the same user User1. Example: To access ...
Apeksha's user avatar
  • 11
1 vote
1 answer
161 views

Disallow superusers and single-user mode in POSTGRESQL

I have a doubt about superusers and single-user mode. I want to restrict the access to a certain database, in a way that only those users which I gave privileges can see the structure of my database. ...
Duskel's user avatar
  • 13
1 vote
1 answer
164 views

How to use mysql_plugin utility?

I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that Cannot read plugin config file unix_socket. Bad format in plugin ...
SkyRar's user avatar
  • 125
0 votes
1 answer
474 views

Authorization dbo maps to a user with an old machine name

I am trying to run a command that looks like this: Create ASSEMBLY [AssemblyName] AUTHORIZATION [dbo] From ... When this runs, it returns an error message: Could not obtain information about Windows ...
Yaakov Ellis's user avatar
0 votes
1 answer
3k views

Designing a database structure for a permissions system

Scenario I would now like to implement a permission system so that a user is able to restrict access on his contact properties to his connections, e.g.: A wants to allow B to access his name, ...
schacker22's user avatar
12 votes
1 answer
11k views

How to prevent a login from 'listing' a table or view definition in PostgreSQL?

Is there a way to prevent a login from listing the tables and columns in a schema? I have to give access to a remote login to query on a single view; however, I also must make sure that such login ...
Silvano González's user avatar
1 vote
1 answer
212 views

Permission for business logic layer & application

I'm very new into db development and currently working on my first production app. I learned that I would need a business logic layer (BLL) to authenticate and authorize users, for example: John can ...
Ryan's user avatar
  • 313
1 vote
1 answer
63 views

Problem when extracting the structure of DB2 (Back up Structure)

I want to extract the structure of a 9.7 DB2 database to use to clone it but some of the authorization statements are missing afterwards: I tried something like this: db2look -d dbName -a -x -o ...
Entomo's user avatar
  • 111
0 votes
1 answer
10k views

alter authorization in SQL Server

I will to made a database diagram in my SQL Server Management Studio. But I have this warning that said: Database diagram support objects cannot be installed because this database does not have a ...
H. Pauwelyn's user avatar
6 votes
0 answers
440 views

Roles and policies in Postgresql 9.5 row-level security

Following the the info in posts like these i would like to use the role system and policies, i.e. each user in my system would have a db role. I want to model the following properties but i can't come ...
Ruslan Talpa's user avatar
7 votes
1 answer
11k views

Create postgres schema in db with multi user in AUTHORIZATION

Is it possible to create a schema that is owned or accessible by more than one user in the same database? I was reading postgres create schema documentation and postgres alter schema documentation ...
tymik's user avatar
  • 175
1 vote
0 answers
38 views

Will SSRS User rights be over-ridden by Windows account?

If a Reporting Services user group has all rights on SRS Report Server folder, and one of the group member's Windows Account has been added to the folder with Browse only, will SQL server cause that ...
RickNPHX's user avatar
0 votes
1 answer
535 views

access denied when mysql to localhost using public ip

I would like to use the command below to connect to my Mac's local database (xx.xxx.xxx.xxx is the Mac's ip address) mysql -u cgao -h xx.xxx.xxx.xxx -p and I got the error message: ERROR 1045 (...
cgao's user avatar
  • 1
0 votes
0 answers
3k views

workbench failed to connect -- ssh

What are the connection parameters? How do I confirm each value? Workbench error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 I can easily ...
Thufir's user avatar
  • 121
0 votes
2 answers
861 views

Oracle remote OS authentication, security risks with domain users

What security risks can be with domain users? create user "OPS$KA\USERNAME" identified externally. grant create session to "OPS$KA\MARIK"; Then MARIK that is in KA domain, can logon to the database ...
kupa's user avatar
  • 1,707
1 vote
0 answers
596 views

user rights validation inside stored procedure?

You have an application with a Users table, and the Users table has various columns to indicate what rights a User has within the application. Ignoring for the purposes of this question what should ...
mg1075's user avatar
  • 755
2 votes
1 answer
9k views

How to grant rights for a user in DB2 Express?

I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database. I have ...
kampi's user avatar
  • 135
2 votes
1 answer
590 views

How to avoid large joins when determining which rows a user is authorized for?

Typical wep app situation: you have logged in users querying for resources exposed through an API. As a hypothetical example, company administrators quering for their employees' time sheets: company &...
glitch's user avatar
  • 135
14 votes
1 answer
26k views

PostgreSQL: permission denied for relation

I'm a bit confused about setting permissions in PostgreSQL. I have these roles: List of roles Role name | Attributes | Member of ---...
Meltemi's user avatar
  • 787
5 votes
2 answers
13k views

Why database diagrams are not working when domain account is attached to database owner?

I was trying to use Database diagrams is SQL Server and got following error: Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first ...
jrara's user avatar
  • 5,333
1 vote
1 answer
2k views

How to implement an effective ACL/auth in a relational db?

We are looking at implementing an ACL that fulfills the following requirements: Most users have access to an item (access to the item by default), but a few is denied access. Most users do not have ...
chriscena's user avatar
  • 111
2 votes
2 answers
3k views

MySQL Views Authorization

Questions: Is there a way, using SQL, to identify how many views are in the database per user? How can you authorize/deny users access to delete views created by another user?
neeraj's user avatar
  • 260
3 votes
2 answers
2k views

How to hide metadata from Postgres users?

I need to provide views-only access to some subset of a database, for use by report-writing tools. It's easy enough to use permissions to prevent access to the data in the underlying tables, but I ...
user1608's user avatar
3 votes
1 answer
2k views

Is it possible to specify Active Directory username and password in connection string?

My organization uses Active Directory to control access to our databases. Building web applications and as part of our CI process I would like to specify the credentials in the connection string. Is ...
detroitpro's user avatar
2 votes
2 answers
571 views

Transferring concepts - users/groups/permissions of db objects from mysql to postgresql

This seemed like a better fit here than stackoverflow, so here goes: I've been using mysql for a while since on most of the cheap webhosts it is the provided database. However, now I've started ...
user avatar
8 votes
3 answers
2k views

MySQL LDAP authentication

Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How it's organized? Thanks.
Yasir Arsanukayev's user avatar