sql-grant
Granting Rights on Stored Procedure to another user of Oracle
I am a studen开发者_运维百科t of Undergraduate studies , and I am facing little problem in granting rights of ownership to a user A to a stored procedure being owned by user B in database Oracle 10g m[详细]
2023-01-27 16:13 分类:问答Can I create a group/user role in postgres so that it can only execute predefined functions?
I want to make a database user, which would use my predefined functions (login(pass, login), get_users_you_are_in_charge_off(login, pass) etc.).[详细]
2023-01-24 20:32 分类:问答Oracle Create View issue
I am logged in as the dba account and I want to create a view in User1\'s schema, but selecting data from User2\'s.[详细]
2023-01-22 23:45 分类:问答Update The database using applets
I have written a code in JAVA to search files from the system.User specifies the filename and extension on text input on applet window and on button click code establishes a connection to oracle datab[详细]
2023-01-20 13:19 分类:问答Why is GRANT not working in MySQL?
I\'m scratching my head on this one as I see a ton of helper websites showing how to create MySQL users and grant privileges but for some reason it just does not work for me.I tried on both WinXP and[详细]
2023-01-19 17:08 分类:问答grant select for temporary table in MySQL
I ha开发者_开发知识库ve 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 cr[详细]
2023-01-14 16:53 分类:问答Grant on multiple databases. MySQL
How to grant on multiple databases? MySQL. Someth开发者_开发问答ing like GRANT SELECT,INSERT,UPDATE,DELETE,CREATE[详细]
2023-01-06 06:33 分类:问答Oracle: where can I query java grants?
I need to check the current user\'s java grants, something similar to what has been set by: dbms_java.grant_permission(\'SCOTT\',\'java.net.SocketPermission\',\'*\',\'connect\');[详细]
2023-01-06 03:12 分类:问答Grant a user permission to only view a MySQL view and nothing else
This question was originally using MySQL 5.1.44, but is applicable to MySQL 8.0+ too. Let\'s say I have a table with records inserted by different users of my application. How can I give a specific us[详细]
2023-01-04 09:33 分类:问答Oracle grant concession and side effects
Working every day on a large Oracle production database (10g), we noticed that operations like granting an user read privileges on a table[详细]
2023-01-03 16:35 分类:问答