I am synchronizing tables using a stored PL/SQL procedure as part of a web application - when they hit a button it does the sync. The PL/SQL is executing as user A, but needs to disable indexes and sync a couple of tables in schema B. I can't get user A to 'alter index B.indexName unusable' despite granting it 'alter any index', and in...
I need to see all grants on an Oracle DB. I used the TOAD feature to compare schemas but it does not shows temptable grants etc. so there's my question: How can I list all grants on a Oracle DB? ...
Hi, I currently have 2 schemas, A and B. B has a table, and A executes selects inserts and updates on it. In our sql scripts, we have granted permissions to A so it can complete its tasks. grant select on B.thetable to A etc,etc Now, table 'thetable' is dropped and another table is renamed to B at least once a day. rename someot...
I tried to grant CONNECT to a user through a role: CREATE ROLE my_role IDENTIFIED BY "passwd"; GRANT CONNECT TO my_role; CREATE USER my_user IDENTIFIED BY "passwd"; GRANT my_role TO my_user; When I try this in 10g it works fine, while in 11g login is rejected: ORA-01045:user MY_USER lacks CREATE SESSION privilege; logon denied Gran...
Hi, I need help to set GRANT CREATE, ALTER BUT DENY DROP DB Objects to db users using sql server 2008. I've tried this but it returns error: use DBName GO DENY DROP TO dbUser Error: Incorrect syntax near 'DROP'. Any help would be much appreciated. Many thanks.. rfs ...
I have a MySQL DB with a user that has access only a few tables. This user has been granted CREATE TEMPORARY TABLES for this database and by watching the query logs, I can see them create a temporary table and then fail while trying to select from it. Doing GRANT SELECT ON TABLE 'db'.'tmp_tbl' TO 'user'@'localhost'; doesn't work as the t...