Questions tagged [authorization]
The authorization tag has no usage guidance.
34
questions
0
votes
0
answers
297
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
913
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
111
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
39
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
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 ...
- 13
0
votes
1
answer
1k
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 ...
- 21
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 ...
0
votes
1
answer
48
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
153
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
160
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
...
- 125
0
votes
1
answer
463
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, ...
11
votes
1
answer
10k
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 ...
- 213
1
vote
1
answer
204
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 ...
- 313
1
vote
1
answer
62
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 ...
- 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 ...
- 930
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 ...
- 211
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 ...
- 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 ...
- 11
0
votes
1
answer
531
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 (...
- 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 ...
- 121
0
votes
2
answers
850
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 ...
- 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 ...
- 735
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 ...
- 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 &...
- 135
14
votes
1
answer
25k
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
---...
- 777
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 ...
- 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 ...
- 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?
- 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 ...
- 31
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 ...
- 133
2
votes
2
answers
570
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 ...
user369
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.
- 3,115