Questions tagged [authorization]
The authorization tag has no summary.
36 questions
0 votes
0 answers
32 views
Can I grant read-only access to MongoDB database without creating a user or enabling authentication?
My Questions: Is it possible to share read-only access to my MongoDB database WITHOUT creating a user? Is it possible to grant read-only permissions WITHOUT authentication being enabled on the server? ...
- 1
1 vote
0 answers
28 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 ...
- 11
0 votes
0 answers
421 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 ...
- 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 ...
-1 votes
1 answer
146 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 ...
0 votes
2 answers
52 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 ...
1 vote
0 answers
42 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 ...
- 13
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 ...
- 41
0 votes
3 answers
4k 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 ...
0 votes
1 answer
71 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 -&...
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 ...
- 11
1 vote
1 answer
202 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. ...
- 13
1 vote
1 answer
191 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 ...
- 135
0 votes
1 answer
497 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 ...
- 168
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, ...
