Permissions associated with, or required for, an operation on a database system.

learn more… | top users | synonyms

0
votes
0answers
2k views

'oracle.jdbc.driver.OracleSQLException': ORA-01031: insufficient privileges. (SYS.DBMS_XMLSAVE)

I have this function (written here by someone), placed in the package ENVER.ENCODING_VERIFIER: FUNCTION loadxml_table (p_owner IN VARCHAR2, p_tablename IN VARCHAR2, p_format IN VARCHAR2, p_tmpClob IN ...
1
vote
0answers
921 views

error: must be owner of relation USER_ACCOUNT_ID_seq

I have granted priviledges to a user for testing in PostGreSql: GRANT USAGE ON SCHEMA "MySchema" TO "Tester"; GRANT ALL ON ALL TABLES IN SCHEMA "MySchema" TO "Tester"; GRANT ALL ON ALL SEQUENCES IN ...
2
votes
1answer
1k views

How to view the query of another session in pg_stat_activity without being super user?

I have a Postgresql 9.2 database. Two users are created on this database. When I perform the following query as superuser, I can see everything. select * from pg_stat_activity However, is it ...
0
votes
1answer
101 views

Annonymous user has no privileges, but still able to show databases?

Output of SHOW GRANTS FOR ''@'localhost'; GRANT USAGE ON *.* TO ''@'localhost' However, when I log in using my default user account, which is later defaulted to an annonymous account by mySQL as ...
2
votes
2answers
2k views

How to grant permission to new user created in mysql?

I want to create new user and want to give them specific permission like inset, update and delete. But how to create new user and give them permission i don't know. Any help please.
0
votes
0answers
104 views

How to grant privileges for a user to create views on specific tables on Oracle SQL?

I just added: GRANT CREATE VIEW TO user1; But it gives user1 access to ALL the tables, I would like them to only have access to the tables where the field X is user1
1
vote
2answers
433 views

Postgres sequence usage

I have an Postgres database with two users: dev and junit. Junit and dev objects are dropped and created regularly. They both have the same objects unshared for tables, however, sequences are shared, ...
1
vote
2answers
181 views

Configure Oracle user in Enterprise Manager to CREATE VIEW on any of his tables

Is it possible to configure an Oracle user in Enterprise Manager, so that he can later create views on any future, yet unknown table in his schema? I am currently running into "ORA-01031 insufficient ...
1
vote
2answers
2k views

How can I create readonly user for backups in PostgreSQL?

Is it true that it is IMPOSSIBLE to create a readonly backup user in PostgreSQL? I've been advised on an IRC channel that you simply can't have a backup only user with no ownership privileges. I ...
2
votes
1answer
214 views

“Set Password” with a limited user

I'm using MySQL 5.6 and I want to have a limited service-user which is able to create/modify the users of my databases. Now my problem is that I can quite figure out what privileges my service-user ...
0
votes
2answers
864 views

Trigger needs dbms_alert declared

A trigger has given me the following: ORA-04098: trigger 'adminuser.DB_ERROR_CHANGE_TRIG' is invalid and failed re-validation and this is when working on altering schemas/triggers/etc from an ...
0
votes
1answer
206 views

MySQL Table rename and Grants

We are in the process of spring-cleaning our production MySQL 5.0 database, and this includes the renaming a number of tables. We are using the following syntax for the rename ALTER TABLE ...
1
vote
2answers
575 views

What are reasonable privileges to grant typical users? [closed]

I find the list of privileges provided by MySQL to be a bit overwhelming. I'm not sure who should have what privileges. In my mind there are three typical users for my situation: root developer ...
2
votes
2answers
11k views

insufficient privileges while executing oracle stored procedure?

Im getting insufficient privileges error while executing the following oracle stored procedure. Im using Oracle Database 10g Express Edition. CREATE OR REPLACE PROCEDURE sp_update_acounts( ...
0
votes
3answers
8k views

Oracle no privileges on tablespace USERS

I have a brand new Oracle database that is giving the error: ORA-01950: no privileges on tablespace 'USERS' I have done: alter user kainaw quota 100M on 'USERS'; grant unlimited tablespace to ...
0
votes
1answer
270 views

Drop privilege to tables only, Not to database

I created a user with drop privilege to a database. How can I create a user who has the privilege to drop tables of a specified database, but not database.
0
votes
2answers
8k views

ORA-01031 while creating a view as DBA

I'm trying to create a view under my DBA schema on Oracle XE. I already did that on the productive database and it worked with a user with a lot lesser privileges than the DBA role. But now I always ...
0
votes
1answer
1k views

How to Drop tables being a SYS user

I am not being able to drop my tables using : drop table <table_name>; command. It says "the table is referencing primary keys of some other tables as foreign keys." , and when I tried to ...
4
votes
1answer
1k views

What are the privileges required to execute a trigger function in PostgreSQL 8.4?

What are the privileges required to execute a trigger function in PostgreSQL 8.4? It seems that the privileges set to a role does not matter to execute a trigger function. I think I have seen some ...
4
votes
2answers
885 views

Compare two Oracle database roles

I'm trying to re-engineer my corporates user managament and want to compare all the roles with each other to find duplicate ones. Doing it by hand is really tiring and I need to compare like 150 ...
0
votes
2answers
3k views

Problem compiling view when it is referencing a table in an other view: insufficient privileges

Oracle 11g R2 Logged on: SYS / AS SYSDBA When I try to compile or create a view that is referencing local schema tables. It works fine. Problem does occur when I try to compile the same view ...
3
votes
2answers
1k views

Allow SELECT on specific column only

I have a User table with 3 column; name, email, password, etc. I would like to create another user that can only SELECT the name column. SELECT name FROM User; -- Ok! SELECT email FROM ...
2
votes
2answers
132 views

MySQL Security permissions

Is it possible in MySQL to block users from executing these statements? DESC "table" SHOW TABLES SHOW CREATE TABLE "table" Or I need to write a MySQL transport port wrapper ? GRANT ON TABLE does ...
2
votes
1answer
23k views

How to grant all privileges on all tables in a schema to a user in IBM DB2?

At first place, I want to export database from IBM DB2 AIX into IBM DB2 windows. Unfortunately, I can't use BACKUP and RESTORE command because of difference OS issue. So I have to resort to db2move ...
3
votes
2answers
597 views

Change built-in default privileges in PostgreSQL?

Introduction. When I create a database, postgres=# CREATE DATABASE test2 OWNER test2; it is created with an empty privileges column: Name | Owner | Encoding | Collate | Ctype | ...
-3
votes
3answers
10k views

Creating an admin user in Oracle

How can I create a "root" (like on MySQL) in Oracle? I installed Oracle database on my system, for homework, for school (faculty) but it didn't give me the option to make a root user. Well at least I ...
0
votes
1answer
106 views

PostgreSQL, How to keep only one schema?

I don't want some users be available to create schemas, and only use the public schema. I'd like to remove the permission of creating schemas, but I can't found anything on PotsgreSQL 9.1 ...
0
votes
1answer
315 views

Which privileges for MySQL extended status?

If I want to execute "SHOW STATUS" within MySQL or use "mysqladmin extended-status" on command line with a non-root user, which privileges would this user then need?
3
votes
2answers
1k views

Can I delegate SQL Agent rights without granting sysadmin rights?

I'd like to give a user the ability to administer SQL Agent jobs. According to the doc page, I can do this by granting the "appropriate" roles on msdb. I've granted all three SQLAgent% roles, but ...
0
votes
2answers
438 views

Why does this procedure raise a privilege error?

I am having trouble getting the following procedure to run on a remote MySQL database - the given error is privilege based (#1227). Locally, the procedure runs fine. QUESTIONS Could somebody help ...
1
vote
1answer
749 views

How to grant only functions while revoking tables?

I am a newbie to PostgreSQL, and configuring a new database. I wrote several functions for indirect access(read/write) to data, and I want to prohibit all direct access to table. GRANT CONNECT ON ...
5
votes
3answers
2k views

Do roles have an owner in oracle?

Suppose that I have logged in to oracle database using user X, then user X creates some roles using create role command. I want to know that is user X the owner of the roles? Can I select all roles ...
9
votes
2answers
12k views

Permission denied in Postgres

I added the user myuserto Postgres. Then I added the database mydatabase in the pgAdmin III GUI and restored from a backup file. So the owner of mydatabase is the superuser postgres. Then I tried to ...
4
votes
3answers
25k views

“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?

Earlier I created a user : SQL>create user suhail identified by password SQL>User created. SQL>Grant create session,create table to suhail; SQL>Grant Succeeded. but when I login as ...
2
votes
2answers
457 views

EMS SQL manager permission problem

I have a strange problem with EMS SQL Manager. I'm using MySQL 5.5 with linux servers. One of my developers need to edit store procedure, so I grant him: GRANT CREATE ROUTINE, ALTER ROUTINE ON ...
2
votes
1answer
650 views

ORA-16000 when trying to perform select on read only Oracle database

My application's SQL encounters an ORA-16000 error when trying to access a read only Oracle database. ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE", line 272 ORA-06512: ...
0
votes
1answer
4k views

ORA-00990 error while trying to grant priviliges: Why is that? [closed]

After creating a user named suhail I am trying to grant that user some privileges. But I am getting an error saying missing or invalid privilege . Why is that ? C:\Windows\system32>SQLPLUS / AS ...
2
votes
2answers
1k views

mysqldump: flush-privileges option

I'd like to get some clarification about the --flush-privileges option for mysqldump. Here's the description of the option from the MySQL docs: --flush-privileges Send a FLUSH PRIVILEGES ...
1
vote
1answer
109 views

In Oracle, will certain users only be able to see certain data in the privileges tables?

I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user. For the privileges views (data ...
1
vote
2answers
2k views

how to import mysql system “mysql” database [closed]

This question might be already answered but it's almost impossible to google it. When I perform full backup of mysql server using mysqldump --all-databases then reinstall it from scratch I want to ...
0
votes
1answer
2k views

Oracle create user with privileges to grant references

I want to create an Oracle user who can grant references to other users. Do I need to make him sysdba for that, or is there any other way?
1
vote
1answer
107 views

mysql allow access for localhost and named server

Hope we're enjoying this Fine Friday afternoon and getting ready for the weekend. I've got a quick question. I'm trying to set up a user to allow them access from localhost and from a specific named ...
1
vote
1answer
532 views

Can't SHOW GRANTS after MySQL re-install [closed]

I had to completely re-install MySQL on one of the slaves and then rebuild it via a sql dump (we have 1 master and 2 slaves). I tried to SHOW GRANTS for one of the users, but keep getting the ...
2
votes
1answer
192 views

GRANT privileges to table elements

What happens if I GRANT priveleges (for example SELECT) ON a table TO some group role? What privileges will the table's elements have in this case: indexes, sequences, columns? Should I explicitly ...
3
votes
1answer
6k views

How to connect multiple users/schemas in Oracle 11g?

I'm almost new user to databases, so I think I'm doing something wrong. I have the database created. I created 3 users, 1 it's an Admin, 2 are just users. I created 2 roles, 1 for the Admin and 2 ...
5
votes
2answers
19k views

How do I automatically grant all privileges to a schema created by a user in mysql?

Someone new joined the company and I created an account for her in mysql using the following: CREATE USER 'username' IDENTIFIED BY 'password' She needs to create her own schema and so used: GRANT ...
2
votes
1answer
226 views

Number of virtual tables that specified user is able to write queries in PostgreSQL

I have one question about PostgreSQL that I can't understand. As it seems so far, it needs some of bruteforce in tables. Well, I did that lots of time and I found nothing. So, firstly I will cover my ...
2
votes
1answer
757 views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
2
votes
0answers
230 views

Stored procedure doesn't return results or any messages when executed as other privileged user [closed]

I have many stored procedures with... EXECUTE permission given to role XXXUser. Login XXXLogin is created and assigned to the role of XXXUser There is one particular stored procedure that I have ...
0
votes
0answers
59 views

Give privilege to new created databases in MySQL

I have user "U" who I want to give him full access to all the existing databases except "db1". I want him to only have select privilege for that db. What I did is I gave "U" all permissions for each ...