Questions tagged [privileges]

This tag is for questions relating to the general topic of privileges, without reference to any specific operating system or application.

This tag is for questions relating to the general topic of privileges, without reference to any specific operating system or application.

1503 questions
16
votes
3 answers

Hashing SSNs and other limited-domain information

I'm currently working on an application where we receive private health information. One of the biggest concerns is with the SSN. Currently, we don't use the SSN for anything, but in the future we'd like to be able to use it to uniquely identify a…
Preston Marshall
  • 1,185
  • 1
  • 8
  • 15
16
votes
2 answers

What MongoDB user privileges do I need to add a user to a new/another mongo database?

I have enabled authentication in the MongoDB config file after adding one admin user with the following privileges: userAdmin and userAdminAnyDatabase. Now I connect with this user to the db where this admin user is defined (otherwise I get…
Gabriel Petrovay
  • 20,476
  • 22
  • 97
  • 168
16
votes
4 answers

How to get all privileges back to the root user in MySQL?

I am using MySQL. My root user doesn't have all privileges. How can I get all privileges back to the root user? How to do it step by step?
Steven
  • 24,410
  • 42
  • 108
  • 130
15
votes
3 answers

Show users with any privileges to database. MySQL

i have to select all users with any privileges to database (e.g. database 'mysql'). Any suggestions? Thanks.
Michał Skóra
  • 351
  • 2
  • 6
  • 18
15
votes
3 answers

Does full trust mean the same as Run As Administrator

Does full trust mean the same as Run As Administrator? I have read things stating that "for this to work, the application must be a full-trust application." Is that the same as you must have administrator privileges to run the application? If…
Laure Chipman
14
votes
2 answers

pgadmin: getting "DETAIL: User does not have CONNECT privilege." error

I’m using pgAdmin III on Mac Yosemite. I created a role “discount” and a database “discount”. In the pgadmin tool, how do I give the user “discount” connect privileges (and table read/write privileges) to the database “discount”? Currently, when I…
Dave
  • 15,639
  • 133
  • 442
  • 830
13
votes
3 answers

Install Clang as User (no Root Privileges)?

I have access to a shell account at University as a user but with no root privileges. The server is running Ubuntu 8.04 - Hardy. I wish to use Clang as my C compiler for next semester's Unix programming course. GCC is installed but not Clang, and…
haziz
  • 12,994
  • 16
  • 54
  • 75
13
votes
5 answers

PostgreSQL search_path change not working as advertised

I am using PostgreSQL 9.0.3 on RedHat. The database contains two schemas, public and wh. I created a new role called django. I want this user to use the wh schema as it's default. Following the manual, I did: ALTER USER django SET SEARCH_PATH TO…
talonsensei
  • 225
  • 2
  • 3
  • 12
13
votes
3 answers

Calling CreateProcessAsUser from C#

I've been attempting to create a new process under the context of a specific user using the CreateProcessAsUser function of the Windows API, but seem to be running into a rather nasty security issue... Before I explain any further, here's the code…
Noldorin
  • 144,213
  • 56
  • 264
  • 302
13
votes
6 answers

Detect if running with administrator privileges under Windows XP

I am trying to work out how to detect whether a user is running with admin rights under Windows XP. This is fairly easy to do in Vista/Win7 thanks to the whoami command. Here's a snippet in Ruby for how to do it under Vista: Note, the following link…
Charles Roper
  • 20,125
  • 20
  • 71
  • 101
13
votes
8 answers

How can I ensure that there is one-and-only-one row in DB table?

I would like to ensure that my MySQL table named "myTable" has one-and-only-one row. So I need to be able to do Update on this row but obviously Insert and Remove should be not possible. I am asking this question because of this Stack Overflow…
benjisail
  • 1,646
  • 5
  • 21
  • 35
13
votes
2 answers

How to grant execute on dbms_lock in Oracle?

I need to use dbms_lock.sleep procedure from user usr1. I can't login as sys, but I have a password for user usr2 which have "grant any object privilege" privilege. However, when I'm logged in as usr2 and try to issue grant execute on sys.dbms_lock…
Tomasz Żuk
  • 1,288
  • 1
  • 12
  • 14
12
votes
6 answers

create db and user mysql and set privileges php

Is there a way to create a new MySQL database, a new MySQL user and give the new user privileges on the new database all using PHP?
user1218364
  • 153
  • 1
  • 3
  • 7
12
votes
3 answers

How can I list the scheduled jobs running in my database?

I am new to oracle. I need to get the scheduled jobs in my database. I queried DBA_SCHEDULER_JOBS, DBA_SCHEDULER_SCHEDULES, DBA_SCHEDULER_PROGRAMS, DBA_SCHEDULER_JOB_CLASSES, DBA_JOBS. But Oracle issues the error "ORA-00942: table or view does…
988875
  • 1,477
  • 3
  • 12
  • 12
12
votes
6 answers

New users can't login on PHPmyadmin

I am currently having a problem with allowing multiple users to login with phpmyadmin without seeing each other's databases. I am using this method: http://alandoyle.com/tutorials/configuring-phpmyadmin-for-multiple-users/ While the method works for…
GB001
  • 121
  • 1
  • 1
  • 3