Stack Overflow
Stack Overflow

Questions tagged [user-permissions]

For questions regarding the appropriate use, settings, and enforcement of user permissions, typically for the purpose of either providing access to shared resources or restricting access to private resources.

Because permissions paradigms can change fairly drastically across operating systems and coding frameworks, setting appropriate permissions for users can be a daunting task that requires a great deal of knowledge about what kinds of access are both safe and necessary for a given task.

Restricting access too much can result in systems that are brittle and frustrating to users. Leaving permissions too open can lead to security and privacy issues. As such, finding the right balance for each application is paramount.

1163 questions
267
votes
19 answers

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

I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and stored procedures, either directly or due to roles, etc. This report would…
Jeremy
  • 44,950
  • 68
  • 206
  • 332
180
votes
9 answers

How do I use su to execute the rest of the bash script as that user?

I've written a script that takes, as an argument, a string that is a concatenation of a username and a project. The script is supposed to switch (su) to the username, cd to a specific directory based upon the project string. I basically want to…
Son of the Wai-Pan
  • 12,371
  • 16
  • 46
  • 55
120
votes
2 answers

How long should I wait after applying an AWS IAM policy before it is valid?

I'm adding and removing AWS IAM user policies programmatically, and I'm getting inconsistent results from the application of those policies. For example, this may or may not succeed (I'm using the Java 1.6.6 SDK): Start with a user that can read…
Ed Norris
  • 4,233
  • 5
  • 27
  • 29
107
votes
3 answers

iOS 10 - Changes in asking permissions of Camera, microphone and Photo Library causing application to crash

iOS 10, Now Requires User Permission to Access Media Library, Photos, Camera and other Hardware like these. The solution for this is to add their keys into info.plist with a description for user that how we are using their data, I could only find a…
Syed Ali Salman
  • 2,894
  • 4
  • 33
  • 48
74
votes
4 answers

What's the difference between staff, admin, superuser in django?

Django has superuser, staff, admin… superuser and staff are in django.contib.auth.models.UserManager. Then there is the createsuperuser command of django-admin. Well, there are admin apps… What's the difference?
eugene
  • 39,839
  • 68
  • 255
  • 489
70
votes
9 answers

How can I get the Unix permission mask from a file?

How can I get a file's permission mask like 644 or 755 on *nix using python? Is there any function or class for doing that? Thank you very much!
davidx
  • 877
  • 1
  • 8
  • 6
39
votes
4 answers

MySQL grant all privileges to database except one table

I've been unable to find a reasonable solution to achieve the following: I wish to have a user that has ALL privileges on a database (or series of databases with the same schema), except for one table, to which they will only have SELECT…
xzyfer
  • 13,937
  • 5
  • 35
  • 46
36
votes
9 answers

I need an Amazon S3 user with full access to a single bucket

I have a user foo with the following privileges (it's not a member of any group): { "Statement": [ { "Sid": "Stmt1308813201865", "Action": "s3:*", "Effect": "Allow", "Resource": "arn:aws:s3:::bar" } ] } That user…
Kit Sunde
  • 35,972
  • 25
  • 125
  • 179
36
votes
5 answers

Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL

I am having an issue with sqlite db in Android. But as I made a quick research on the internet, I suspect that the problem is not related to sqlite but system user. My app is not recognized as authorized user to access db functionalities. I tried to…
gurkan
  • 3,457
  • 4
  • 25
  • 38
35
votes
2 answers

postgresql database owner can't access database - "No relations found."

I've got an user: user_x that owns a database on postgresql and does not have any ROLE attribute like (CREATE_DB, SUPERUSER,...) This user_x can access the whole DB, create tables (on his database), select, insert and update data. I've got this list…
AndreDurao
  • 5,600
  • 7
  • 41
  • 61
34
votes
3 answers

How can one dry run a git push to check whether one has write permissions to a remote?

Is there a way to dry run a git push to know whether the user has permissions to actually create a new remote branch? I'd like to be able to verify that all is good in regards to permissions for a bunch of repos where the user will attempt to create…
David
  • 3,324
  • 2
  • 27
  • 31
24
votes
5 answers

Why does docker container prompt "Permission denied"?

I use following command to run a docker container, and map a directory from host(/root/database) to container(/tmp/install/database): # docker run -it --name oracle_install -v /root/database:/tmp/install/database bofm/oracle12c:preinstall…
Nan Xiao
  • 16,671
  • 18
  • 103
  • 164
24
votes
2 answers

New to docker, is it possible to protect my source code and add permissions?

I am interested in using Docker to host a project I am helping develop in work. However I have a few questions about it's suitability. Firstly, I wonder is it at all possible to keep the source code hidden from potential users/customers? Obviously…
User588233
  • 481
  • 2
  • 5
  • 16
23
votes
6 answers

How to implement Role based restrictions/permissions in react redux app?

I have a React-Redux-KoaJs application with multiple components. I have few user roles as well. Now i want to display few buttons, tables and div to only specific roles and hide those from others. Please remember i dont want to hide the whole…
Harshit Agarwal
  • 2,308
  • 2
  • 15
  • 23
22
votes
5 answers

Android Wifi Direct: Avoiding user acceptance when connecting to a known peer

While connecting to a peer using WiFi Direct, user's permission is required. I know that connection can't be made without user never giving the permission and there's a feature request for this kind of…
bishwas.bhatta
  • 221
  • 2
  • 4
1
2 3
…
77 78