Grant privileges in Oracle Post: 302369366

Sponsored Content

Top Forums Programming Grant privileges in Oracle Post 302369366 by Scott on Saturday 7th of November 2009 07:28:37 PM

11-07-2009

Administrator Emeritus

Hi.

What do you mean by:

Quote:

i give the privileges as "select on" to user1

Select on what?

Who does the table belong to? If it belongs to a different user (schema) then the owner should grant you select.

i.e.

Code:

SQL> show user
USER is "USER12"
SQL> select * from scott.emp;
select * from scott.emp
                    *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> conn scott/tiger
Connected.
SQL> grant select on emp to user12;

Grant succeeded.

SQL> conn user12/user12
Connected.
SQL> select count(1) from scott.emp;

  COUNT(1)
----------
        14

SQL> show user
USER is "USER12"

SQL> select grantor, grantee, table_name from user_tab_privs;

GRANTOR                        GRANTEE                        TABLE_NAME
------------------------------ ------------------------------ ------------------------------
SCOTT                          USER12                         EMP


SQL> select view_name from all_views where view_name like '%PRIV%' order by 1;
...
...

There's a bunch of data dictionary views which can give you the info you're after.

Catalog Views / Data Dictionary Views

Scott

View Public Profile for Scott

Find all posts by Scott

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

MySQL GRANT permission.

Hi, I'm one of a server administrators. I've the linux root account but I don't know the root password of MySQL (Server version: 5.0.32). I want to GRANT ALL PRIVILEGES to my MySQL account without changing the MySQL's root password. How can I do so?

2. Linux

grant root privileges to ordinary user

Hi, Is it possible to grant root privileges to an ordinary user? Other than 'sudo', is there some way under Users/Groups configuration? I want ordinary user to be able to mount, umount and use command mt. /Brendan

3. UNIX and Linux Applications

grant usage to users listed in a file

hi, i'm trying to grant usage to multiple users whose ids are in a file. i thought that i could put the mysql code within a while loop, but that's not working for me: while read user; do userid=$user passwd="changeme" query="grant usage on mysql.USERS.* to $userid...

4. Solaris

Grant print related privileges

Afternoon everyone, I would want to ask that how/what privileges i should grant to a new user so that the user can clear /disable printing job queue? Solaris OS: 5.9 Thanks. :b:

5. UNIX for Dummies Questions & Answers

grant sudo permission

Hi all, I have to grant sudo permission to a user. I have searched online and find that /etc/sudoers file needs to be changed with visudo command. As i am new to linux, this is not clear to me. Can anybody take an example and show me how exactly this done. Thanks in advance!

6. UNIX for Advanced & Expert Users

Unix privileges for Oracle user

Hi I have an issue I am currently trying to execute Unix Commands through a Java Source within Oracle 10g I am currently running Oracle on a Unix Sun Solaris Platform. I am executing the Java Source through a PL/SQL and on SQL Navigator it is saying that it has been executed. I'm...

7. Shell Programming and Scripting

How can i prepare grant staement with 2 files ?

---file1 ( tables A B C D E F ... ... Z ---file2 Joe Bob Mary Sally Fred Elmer David

8. UNIX for Beginners Questions & Answers

Solaris, grant user to kill another process

the task is grant user1 to kill another (for example user2) process. My steps: by root: usermod -P "Process Management" user1 login user1 user1@server (~) pfexec kill <PID> the result is: ksh: <PID>: not found or user1@server (~) pfexec pkill <PID> the result: nothing happens, still...

LEARN ABOUT PHP

oci_set_action

OCI_SET_ACTION(3)														 OCI_SET_ACTION(3)

oci_set_action - Sets the action name

SYNOPSIS

       bool oci_set_action (resource  $connection, string  $action_name)

DESCRIPTION

	Sets the action name for Oracle tracing.

	The action name is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL statement
       is executed.

	The action name can subsequently be queried from database administration views such as V$SESSION. It can be used for tracing and  monitor-
       ing such as with V$SQLAREA and DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE.

	The value may be retained across persistent connections.

PARAMETERS

	      o $connection
		-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).

	      o $action_name
		- User chosen string up to 32 bytes long.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Setting the action

	      <?php

	      $c = oci_connect('hr', 'welcome', 'localhost/XE');

	      // Record the action
	      oci_set_action($c, 'Friend Lookup');

	      // Code that causes a roundtrip, for example a query:
	      $s = oci_parse($c, 'select * from dual');
	      oci_execute($s);
	      oci_fetch_all($s, $res);

	      sleep(30);

	      ?>

	      // While the script is running, the administrator can see the actions
	      // being performed:

	      sqlplus system/welcome
	      SQL> select action from v$session;

NOTES

       Note

	      Oracle version requirement

	      This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.

       Tip

	      Performance

	      With  older  versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
	      age. This is less efficient than using oci_set_client_info(3).

       Caution

	      Roundtrip Gotcha

	      Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur  with	queries  when  result  caching	is
	      enabled.

SEE ALSO

       oci_set_module_name(3), oci_set_client_info(3), oci_set_client_identifier(3).

PHP Documentation Group 													 OCI_SET_ACTION(3)