Top "Privileges" questions

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

Getting ORA-01031: insufficient privileges while querying a table instead of ORA-00942: table or view does not exist

When I'm querying a table in schema C from schema A, I'm getting ORA-01031: insufficient privileges and when I'm querying …

oracle privileges
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 …

mysql privileges
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 …

mysql database privileges grant
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, …

mysql ubuntu phpmyadmin privileges grant
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 …

windows windows-7 privileges administrator runas
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 …

sql stored-procedures oracle10g privileges
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 …

xcode macos osx-snow-leopard privileges dscl
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 …

postgresql privileges data-dictionary
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, …

sql oracle jobs privileges
"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 …

mysql privileges grant