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
70
votes
2 answers

What registry access can you get without Administrator privileges?

I know that we shouldn't being using the registry to store Application Data anymore, but in updating a Legacy application (and wanting to do the fewest changes), what Registry Hives are non-administrators allowed to use? Can I access all of…
Kris Erickson
  • 33,454
  • 26
  • 120
  • 175
69
votes
5 answers

"IDENTIFIED BY 'password'" in MySQL

I often see in many MySQL tutorials that people use command IDENTIFIED BY 'password' both during user creation and granting him privileges. For example: CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON database.*…
user3461823
  • 1,303
  • 2
  • 11
  • 17
69
votes
2 answers

Remove privileges from MySQL database

Before you think this is a duplicate question, I believe I have a unique, even if it is somewhat dim-witted, case. A few days ago, I upgraded the version of MySQL on my Ubuntu 10.04 server to 5.3.3 (it's ahead of the Ubuntu releases for 10.04).…
Cyntech
  • 5,362
  • 6
  • 33
  • 47
67
votes
8 answers

What precisely does 'Run as administrator' do?

On Windows 7, I have a command-line program that fails due to file write permission errors, and popping up annoying UAC dialogs every time I run command-line programs that are from an 'unknown publisher'. However, if I start my console by right…
Jonathan Hartley
  • 15,462
  • 9
  • 79
  • 80
60
votes
4 answers

PostgreSQL: Show all the privileges for a concrete user

How to make a query to the Postgres data dictionary to find out all the privileges that a particular user has. I've been looking for a solution and I can not find anything. Thanks and good day
Python241820
  • 1,017
  • 1
  • 12
  • 16
54
votes
3 answers

Check for administrator privileges in C#

I want to know if a program is running as administrator. The user doesn't have to be administrator. I only want to know if my application has rights to edit some secured files that are editable when running as Administrator.
Hooch
  • 28,817
  • 29
  • 102
  • 161
51
votes
12 answers

Spring Batch Framework - Auto create Batch Table

I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. When I try to run the batch job I hit the error while the framework tried to create TABLE_BATCH_INSTANCE. I try to disable the…
Einn Hann
  • 651
  • 2
  • 8
  • 17
51
votes
5 answers

"root" execution of the PostgreSQL server is not permitted

When I try to start postgresql I get an error: postgres postgres does not know where to find the server configuration file. You must specify the --config-file or -D invocation option or set the PGDATA environment variable. So then I try to…
chopper draw lion4
  • 12,401
  • 13
  • 53
  • 100
50
votes
2 answers

Privileges/owner issue when writing in C:\ProgramData\

As pointed out in Writing config file in C:\Program Files (x86)\MyApp\myapp.cfg, vs. Administrator privilege, it is not a good idea to write a config file in C:\Program Files (x86)\MyApp\myapp.cfg. Instead of this, my software now saves its data in…
Basj
  • 41,386
  • 99
  • 383
  • 673
42
votes
4 answers

Execute Immediate within a stored procedure keeps giving insufficient priviliges error

Here is the definition of the stored procedure: CREATE OR REPLACE PROCEDURE usp_dropTable(schema VARCHAR, tblToDrop VARCHAR) IS BEGIN DECLARE v_cnt NUMBER; BEGIN SELECT COUNT(*) INTO v_cnt FROM all_tables WHERE owner =…
tundal45
  • 193
  • 3
  • 14
  • 33
41
votes
4 answers

RealUID, Saved UID, Effective UID. What's going on?

This is a set-root-uid program $ls -l -rwsr-sr-x 1 root root 7406 2011-12-13 22:37 ./x* The source code: int main(void) { printf( " UID GID \n" "Real %d Real %d \n" "Effective %d Effective…
Lelouch Lamperouge
  • 8,171
  • 8
  • 49
  • 60
39
votes
3 answers

PostgreSQL user listing

I want to get a list of users for a certain database in psql - for example "template0". Who are the users? Or for "template1" database: - who are the users there? Already tried: \du+ -- no database is Listed not Users Select * from "pg_users"; --…
Arun Dambal
  • 501
  • 1
  • 4
  • 5
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
38
votes
5 answers

Mysql: execute command denied to user ''@'localhost' for routine error

i got some problem during open my old website. My dataTable show: DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error. After that, I tried to debug my script and found error in mysql: Error…
nunu
  • 2,703
  • 9
  • 33
  • 55
38
votes
4 answers

Grant privileges for a particular database in PostgreSQL

I'm moving from MySQL to PostgreSQL and have hit a wall with user privileges. I am used to assigning a user all privileges to all tables of a database with the following command: # MySQL grant all privileges on mydatabase.* to 'myuser'@'localhost'…
Joe Lapp
  • 2,435
  • 3
  • 30
  • 42