Stack Overflow
Stack Overflow

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
444
votes
12 answers

Permission denied for relation

I tried to run simple SQL command: select * from site_adzone; and I got this error ERROR: permission denied for relation site_adzone What could be the problem here? I tried also to do select for other tables and got same issue. I also tried to…
Bob
  • 8,392
  • 12
  • 55
  • 96
312
votes
8 answers

PostgreSQL: Give all permissions to a user on a PostgreSQL database

I would like to give a user all the permissions on a database without making it an admin. The reason why I want to do that is that at the moment DEV and PROD are different DBs on the same cluster so I don't want a user to be able to change…
Diego
  • 34,802
  • 21
  • 91
  • 134
131
votes
3 answers

CPU Privilege Rings: Why rings 1 and 2 aren't used?

A couple of questions regarding the x86 CPU privilege rings: Why aren't rings 1 and 2 used by most operating systems? Is it just to maintain code compatibility with other architectures, or is there a better reason? Are there any operating systems…
user541686
  • 205,094
  • 128
  • 528
  • 886
129
votes
1 answer

ORA-01950: no privileges on tablespace 'USERS'

I'm getting this error: ORA-01950: no privileges on tablespace 'USERS' I have a default tablespace and I'm able to create tables, however, they do not show at the objects tab in Toad. I cannot insert anything into tables I create.
sam
  • 2,493
  • 6
  • 38
  • 73
128
votes
7 answers

How to show all privileges from a user in oracle?

Can someone please tell me how to show all privileges/rules from a specific user in the sql-console?
destiny
  • 1,802
  • 3
  • 16
  • 18
128
votes
6 answers

I can not find my.cnf on my windows computer

My computer is Windows XP. I need to find my.cnf to get all privileges back to the root user. I accidentally removed some privileges of the root user. I still have the password and there is no problem for me to log in to MySQL as the root user. But…
Steven
  • 24,410
  • 42
  • 108
  • 130
125
votes
3 answers

Why is a "GRANT USAGE" created the first time I grant a user privileges?

I'm new to the admin side of DBMS and was setting up a new database tonight (using MySQL) when I noticed this. After granting a user a privilege for the first time, another grant is created that looks like GRANT USAGE on *.* TO user IDENTIFIED BY…
John M Naglick
  • 1,791
  • 4
  • 14
  • 18
119
votes
10 answers

How can I restore the MySQL root user’s full privileges?

I accidentally removed some of the privileges from my MySQL root user, including the ability to alter tables. Is there some way I can restore this user to its original state (with all privileges)? UPDATE mysql.user SET Grant_priv = 'Y', Super_priv =…
Steven
  • 24,410
  • 42
  • 108
  • 130
116
votes
2 answers

Grant all on a specific schema in the db to a group role in PostgreSQL

Using PostgreSQL 9.0, I have a group role called "staff" and would like to grant all (or certain) privileges to this role on tables in a particular schema. None of the following work GRANT ALL ON SCHEMA foo TO staff; GRANT ALL ON DATABASE mydb TO…
punkish
  • 13,598
  • 26
  • 66
  • 101
112
votes
10 answers

Authorize a non-admin developer in Xcode / Mac OS

I use a standard user account for my daily tasks on Mac OS. Since upgrading to Snow Leopard I am asked to do the following when a program is run from within Xcode: "Type the name and password of a user in the 'Developer Tools' group to allow…
Andrew Cain
  • 1,193
  • 2
  • 10
  • 8
94
votes
10 answers

What is the best way for checking if the user of a script has root-like privileges?

I have a Python script that will be doing a lot of things that would require root-level privileges, such as moving files in /etc, installing with apt-get, and so on. I currently have: if os.geteuid() != 0: exit("You need to have root privileges…
Paul Hoffman
  • 1,820
  • 3
  • 15
  • 20
84
votes
6 answers

How to elevate privileges only when required?

This question applies to Windows Vista! I have an application which normally works without administrative privileges. There is one activity which does need administrative privilege but I don't want to start the application itself with higher…
Hemant
  • 19,486
  • 24
  • 91
  • 127
80
votes
3 answers

Check Postgres access for a user

I have looked into the documentation for GRANT Found here and I was trying to see if there is a built-in function that can let me look at what level of accessibility I have in databases. Of course there is: \dp and \dp mytablename But this does not…
ryekayo
  • 2,341
  • 3
  • 23
  • 51
77
votes
13 answers

How to start MySQL with --skip-grant-tables?

I locked my root user out from our database. I need to get all privileges back to the root user. I have my password and I can log in to MySQL. But the root user has no all privileges.
Steven
  • 24,410
  • 42
  • 108
  • 130
75
votes
11 answers

How do I get column datatype in Oracle with PL-SQL with low privileges?

I have "read only" access to a few tables in an Oracle database. I need to get schema information on some of the columns. I'd like to use something analogous to MS SQL's sp_help. I see the table I'm interested in listed in this query: SELECT * FROM…
James
  • 12,636
  • 12
  • 67
  • 104
1
2 3
…
99 100