How to create a user in Oracle 11g and grant permissions

by

Connect as SYSTEM.

CREATE USER username IDENTIFIED BY apassword;

GRANT CONNECT TO username;

GRANT EXECUTE on schema.procedure TO username;

You may also need to:

GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;

to whichever tables the procedure uses.

More Related Contents:

  1. Maximum Number of times we can query an oracle database [closed]
  2. How to uninstall / completely remove Oracle 11g (client)?
  3. Oracle trigger after insert or delete
  4. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  5. How to handle Day Light Saving in Oracle database
  6. What is the effect of placing the commit after DML in procedure?
  7. Auto Increment for Oracle
  8. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  9. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  10. Oracle Search all tables all columns for string [duplicate]
  11. NLS_NUMERIC_CHARACTERS setting for decimal
  12. creating parameterized views in oracle11g
  13. Create Pivot view in SQL from a SQL table
  14. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  15. Trigger to enforce M-M relationship
  16. How can I describe a table in Oracle without using the DESCRIBE command?
  17. Functions vs procedures in Oracle
  18. How to insert a column in a specific position in oracle without dropping and recreating the table?
  19. Get the number of days between two dates in Oracle, inclusive of the dates
  20. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  21. passing in table name as plsql parameter
  22. How to use parameters in a ‘where value in…’ clause?
  23. Why cannot I create triggers on objects owned by SYS?
  24. No more data to read from socket
  25. return resultset from function
  26. ORA-12704: character set mismatch
  27. No more data to read from socket error
  28. How to send email using Oracle 10 g Forms
  29. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  30. Find out the history of SQL queries

Leave a Comment