GRANT (Schema Privileges) statement
Is it possible to access a table in system/manager by granting TYRES privileges?
Grant select on EMPLOYEE_MSTR to tyres.
Tyres is another user. I wanted to access all the tables stored in SYSTEM/MANAGER when I logged in as TYRES/TYRES. I am using ORACLE 8 and I haven't use this since.
Any help is appreciated.
First of all: you are in the wrong forum (try the database forum).
Then: Yes this is possible, but I strongly suggest that you place specific user objects (tables, etc) in the sys tablespace, and do not access the database as system when not necessary.
Hi, I need to grant DML privileges to all tables in few schemas to a role. How can I achieve that? I thought it's below syntax but it doesn't work. Please advice. grant ALL ON ALL TABLES IN SCHEMA <Schema_name> TO <role_name>;Thanks, Gangadha
I have a request to add the travel schema to one of our 9202 databases. Fairly straight forward. I got the *.dmp file from your site: http://www.oracle.com/technology/sample_code/tech/java/travel/travelschema.htm#system I created the user travel and
Can anyone tell me what privilege needs to be granted to a user to be able to grant insert/update/select/delete/execute on another users tables/packages? I had thought that 'grant any privilege' was the one to have... and - the user I am trying to us
Hello, Here's the situation: I have 2 databases located on 2 different servers both running Win2k3. In the first database the main schema is M1 and it has to read objects on the another schema M2, located on the second database. I created a database
I have two test users set up in different schemas. They each have their own identical queue tables and queues in their own schemas. One of the users cannot seem to grant queue privileges to the main schema owner. The error is as follows: Eception: or
Hi, OS is windows server 2008 Database oracle 11g r2 i have created a schema with name SME having DBA privilege from SME i have created another user SME_USER using the same tablespace of SME with limited privileges. The sequence was created in SME us
About 4 weeks ago i got some much appreciated assistance in setting up my environment so that a user could grant object privileges on objects in another user's schema. This solution required a function to be built in the schema which owned objects. I
Hi, gurus, after successfully upgrading ebs 220.127.116.11 database to 10.2.0.5, we want to create a database user that will have all APPS Schema privileges. Please can anyone help us with all the Privileges,Roles etc that have to be granted to this User.
Hi I am having two databases: DEV1 and DEV2. DEV1 is my source database and DEV2 is target database. There is a table in Schema A on Dev1. I have created a PUBLIC DBLINK "TESTDBLINK" in Schema B on DEV2 that connects to Schema A on DEV1. Databas
We have noticed a situation where an account is repeatedly GRANTing itself privilieges to a hidden type - a SQL type that mirrors a type hidden in a PL/SQL package. The background: Schema USER has execute privilege on package OWNER.PKG. OWNER.PKG is
Can anyone tell me how to grant select privilege to a user for specific columns in a table? I have tried the following statement GRANT SELECT (EMP_ID) ON EMP TO USER1 But it's not working and I am getting this error "Missing ON Keyword". Please
Started getting this when attempting to change Privileges on a proc: "Could not launch the Grant/Revoke Privileges dialog: Value was either too large or too small for an Int32." This is happening consistently on one database but not on another.
How to grant view privilege for Instant Portal to public users?Oracle Instant Portal was designed to offer secure access to company and departmental information, and it isn't currently possible to make instant portal pages public.Read other 2 answers
I want to grant select privileges on all tables and views belonging to database xyz to the user abc. What's the best way to do that? Message was edited by: Diarmuid - 11/07/07 user580522I beg to differ. Of course OP can try to 'GRANT SELECT ANY TABLE
I am running version 18.104.22.168.5 on Solaris 2.6 and using Netscape Navigator 4.51. On the Grant Object Privileges Page for a database object, the "Add to List" button is in an odd spot (crosses over a border) and does not work unless you click it
Hi all, which view I can query to get the granted objects privilege to a user? for example: grant execute on accounting.get_name to scott; Which view has above object granted information? ThanksSQL> select * FROM all_tab_privs where grantor = upper('
Hi, In order to be given to a user -Info_bi let's name him - the grant to select any table from user Info , This user (Info) must be given the system privilege "any privilege".... So : connect sys/[email protected]
as sysdba; Connected to Oracle Databas
Post Author: mwong CA Forum: crystalreports.com Problem Description: I need to grant Administrator privileges to one of my users. How do I do that? He needs to upload the reports and invite the users to view them.Post Author: mwong CA Forum: crystalr
I have a problem. I can't figure out why granting schema object to users take longer time. here is my codes: DECLARE alert_button NUMBER; CURSOR Teller_Cur IS SELECT * FROM TELLER_M; BEGIN alert_button := Show_Alert('AlertOK'); IF alert