PL/SQL :: Give ROLE Access To Users In Developer Tool?
Oct 5, 2013How to give ROLE access to users in PL/SQL developer Tool..??
View 3 Replies
ADVERTISEMENT
Debug The Procedure In PLSQL Developer Tool?
Feb 18, 2009I want to debug the procedure using PLSQL Developer tool?How to use the debug option in that tool?.
View 1 Replies View RelatedSQL & PL/SQL :: Give Access Only On 10th Row For Schema2
Mar 26, 2010I have two schemas.In schema1 i hava a table with 20 records,i want to give access only on 10 th row for schema2.
View 6 Replies View RelatedServer Administration :: How To Give Full Access To Other Schema
Apr 15, 2012I want to get clear with one thing yesterday i installed oracle9i and dev 2000 to my client.
when they run one report they got stuck with pl/sql compilation errorrep-1247
when i checked that report in the report builder, in the query they are using some other table which is not belongs to that schema,then I give that schema.tablename and compiled, but this is coming for other reports also, then only i came to know that they are acceessin other schema also, how can i sort this out.
can i fix this by givin full access privilige or what privilige can i give to get full access of other schema table.
how can i check in the old database what are all the roles and privileges given to this user,
Grant User Access To Role With Limited Exposure?
Oct 23, 2012I have a role in my Oracle 10g instance like below:
GRANT ALTER USER TO <role_name> WITH ADMIN OPTION;
And this works fine for any user who has:
GRANT <role_name> TO <user>;
What I need is to limit <user> to only have the ALTER USER privilege to a set of users. Preferrably where the set of users are identified by a column value in a table, something like:
WHERE PeopleTable.InList = "YES"
Or maybe where set of users are defined by their membership in another role.
GRANT ALTER USER TO <role_name> FOR USERS IN MEMBERS_LIST_ROLE;
Select Access To Users
May 2, 2013Are you aware of any "Best Practice Document" to grant select accesses to users on databases. These users are developers which select data out of database for the investigation and application bug fix.
From time to time user want more and more access to different tables so that they can do investigation properly.
Users With Direct Access To Tables
Dec 11, 2012I need to find out which users have direct access to tables, not through the roles.
Is dba_tab_privs the right table to query or table_privileges is the correct one.
What is the difference between these two.
I have gone through the documentation but I am still not clear about the difference between them.
Let me know whatever your thoughts are on this.
ISQL*Plus :: How To Limit Access To Few Users
Oct 29, 2013I would like to know if it's possible to limit access to isqlplus to only one user in my case. I need to give access in read only mode to user in isqlplus.For that, I will create a oracle user with only select privilege on the tables, but I want to be sure that only this user will be used in isqlplus and not another.
View 1 Replies View RelatedHow To Disable SYSTEM Access From Client Users
Oct 29, 2012My requirement is to disable access of sys user from all clients even they are providing correct password.
View 2 Replies View RelatedApplication Express :: Restricting Access To Users
Dec 22, 2012 restrict access to page or component for particular user. when that user login , restricted page should not be visible to the user..
APEX Verison :4.2
Application Express :: How To Access Data Of All Users In A Page
Jan 23, 2013I have installed APEX on my local machine, created a workspace, and added a few users with roles.
I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?
Application Express :: Access Oracle EBS Environment With Developer-level?
Jan 12, 2013how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?
View 1 Replies View RelatedSecurity :: Any Role Where Exp_full_database Role Is Contained In It?
Aug 13, 2013Is there any Role where 'exp_full_database' role is contained in it? or it is compulsory to grant to the user for exporting objects.,
View 2 Replies View RelatedSQL & PL/SQL :: Connect Role In Dba-role-privs?
Oct 10, 2012But what I noticed is that user HIEL has a connect role but YONC does not. (Result set is below) Have searched for information but did not find what I was looking for. I did read something about backward compatibility.I'm leaning towards that thought since the other user YONC does not have this role.
Database: 11g R1
SQL> select * from dba_role_privs where grantee in ('YONC', 'HIEL') order by grantee;
GRANTEE GRANTED_ROLE ADM DEF
--------------------------- --------------------------- --- ---
YONC WCAIMS_INQUIRY NO YES
YONC ENDUSER NO YES
HIEL WCAIMS_CSR_ADDR NO YES
[code].........
Export/Import/SQL Loader :: Assigned To ROLE X Be Transferred To Role Y Via Datapump Import
Oct 18, 2013i have user with the name 'Rob' and this user has been assigned a role 'MY_SRC_ROLE' . I developed a table under rob schema and granted access to this table via role GRANT DELETE, INSERT, SELECT, UPDATE ON rob.emp TO MY_ SRC_ ROLE; I have 100 more users & they have been granted this role 'MY_SRC_ROLE'. These 100 users can now access emp table via Role 'MY_SRC_ROLE' without any issues. Now i took a datapump export & performed datapump import on target server which is also HP Unix with 11.20.3 .
On target server i have user 'JACK' and a role called 'MY_WORK_ROLE'. 5000 users have been granted 'MY_ WORK_ ROLE' on this server. I have used remap tablespace clause & remap schema clause in datapump import script. Once i performed an import , due to schema remap , i can see JACK now owns table 'emp', however grants are still not there, I tried searching on Google & oracle documentation, if somehow we can remap ROLE GRANTS also while doing datapump imp, but i couldn't find supporting syntax. can i assume datapump import is not capable to handle this particular scenario ? I was able to do it by manipulating sqlfile and replacing role name in that but i am looking for a sol. within datapump itself. how can grants assigned to ROLE 'X' be transferred to 'Role Y' via datapump import.
Create A Role Like DBA Role?
Sep 20, 2012is there a way to create a role just like DBA role?
View 6 Replies View RelatedApplication Express :: ORA-24247 / Network Access Denied By Access Control List
Apr 5, 2013When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
ORA-24247 / Network Access Denied By Access Control List (ACL)
Dec 12, 2012I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18
is it possible to send mails from oracle database in STANDARD Edition?
SQL & PL/SQL :: ORA-24247 / Network Access Denied By Access Control List (ACL)
Nov 15, 2011While Running the proc,it's raising the below error.
Error report:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1
[code]....
SQL & PL/SQL :: Give New ID To Existing Employee?
Mar 13, 2012 want to create a PL/SQL procedure, update_id(id_emp in number), that gives a new id_emp (id_emp=y) to an existing employee (id_emp=x).So before updating the EMP table, we have to :
1- create a new row on EMP(with id_emp=y) that has the same informations of the employee (id_emp=x),
2- update all tables that contains the id_emp column (update <TAB> set id_emp=y where id_emp=x),
3- delete employee (id_emp=x).
The problem is in step 2 : it creates a lot of locks and makes the DB unusable.To deal with this problem, I thought for many solutions, but the problem is how to implement them correctly and efficiently.
Before executing step 2, we have to ensure (through a marker I guess) that all the tables that have the id_emp column, are managed by our session, and any other acces (through SELECT, UPDATE, DELETE, INSERT statment) from another session will be rejected since we have a marker on that table.
When step 2 ends, we release all the tables from the markers.
My simple question : how to achieve this ?
Forms :: How To Give Hyperlinks
Jan 14, 2012i would like to give a hyper link in forms. how it possible, any way to do it.
View 8 Replies View RelatedPL/SQL :: Can Give Name To Block Of Code In SP
Aug 29, 2013Version- 10G I have a stored procedure which contain code like
if () then---update---else if() theninsert --update--------else if()-----------------------end if;end if;end if;
I have to use this code numbers of times in my procedure , is there any way I can give name this code & use it or call it where I need it in my SP.Don't want to make the above code a separate procedure.
SQL & PL/SQL :: Give Select Grant For Few Tables?
Jul 8, 2010I created a user and granted connect,resource priviliges. I gave access to this user for only 5 tables. when i check it later, other tables are also given access. How can i avoid this and give access to selected tables.
View 9 Replies View RelatedPL/SQL :: How To Give A User Administrative Permissions
Oct 15, 2012Suppose I using "scott" user, I need to give administrative permissions to scott. How can I give??
View 6 Replies View RelatedPL/SQL :: How SQL Queries Act In Back End To Give The Result
Jul 22, 2013When we are running a query it is giving us the result based on the conditions .But to know what exactly is happening in the database when we are running a query against it and how finally it returns the result.
View 1 Replies View RelatedClient Tools :: SQL Tool To Use With InForm
Nov 7, 2012I'm a Data Manager recently hired at a small company that uses InForm as our data management tool. We are currently not set up with any type of SQL tool to query the database. Consequently, I feel like I'm trying to clean data with one hand tied behind my back. I have two questions:
1) Is there any sort of built in feature in InForm for using SQL statement to query the data? (I'm not really a fan of the built in Cognos feature.)
2) Any tool that is easy to install/configure?
I'm facing some resistance here, so I'm looking for a really easy/cheap solution. I've used SQL Developer before, and I know that's free, but is it easy to set-up?
Forms :: How To Hide MENU And TOOL Bar
Jun 22, 2012i want hide the content shown in the picture
View 6 Replies View RelatedSQL & PL/SQL :: Capture Queries Run By 3rd Party Tool?
Dec 7, 2011I have this 3rd party tool, which are running SQL queries. I need to see what queries the tool is running and capture them. I enabled tracing but that's not working, as the tool doesn't establish connection, it connects when it has to run the query and then gets disconnected.
View 2 Replies View RelatedForms :: Use Text Tool In Programming?
Feb 3, 2010Can i use Text tool in programming...
i just want to change color at run time of text tool....
i attached a picture must see...
How To Give Table Name Dynamically In A Select Query
Aug 23, 2012I have 12 different tables
Record_jan
Record_feb
.
.
.
Record_nov
Record_dec
Based on the month i need to do some i/o operations from these table.
For eg: If it is january then Record_jan table should be accesed or for nov Record_nov table should be accesed.
If I try to store the table name in some variable and then give the variable name in place of table name then it gives error.
var:=Record_month;
Select * from var;
this gives error.