Mega Code Archive
Search
.Net
ASP .Net
ASP .Net Tutorial
C#
C# Book
C# by API
C# Tutorial
VB.Net
VB.Net by API
VB.Net Tutorial
Visual C++ .Net
VisualBasic Script
Java
Java
Java Book
Java by API
Java Tutorial
Script
Flash ActionScript
Flex
JavaScript DHTML
JavaScript Reference
JavaScript Tutorial
Database
MSSQL
MSSQL Tutorial
MySQL
MySQL Tutorial
Oracle PLSQL
Oracle PLSQL Tutorial
PostgreSQL
Languages
Android
C
C Tutorial
C++
C++ Tutorial
Delphi
Perl
PHP
Python
Python Tutorial
Ruby
Silverlight
Office
MSOfficeExcel 2007 Tutorial
MSOfficePowerPoint 2007 Tutorial
MSOfficeWord 2007 Tutorial
Data
XML
XML Tutorial
Oracle PLSQL
User Previliege 81 codes
Home
Oracle PLSQL
User Previliege
1 Add the additional ALL clause to a GRANT statement in order to grant all possible privileges
2 Alter outline name
3 Alter outline to change the category
4 Alter user to change password
5 Alter user to change the password
6 Alter user to grant new quota value
7 Alter user to lock or unlock the account
8 Assign CONNECT and RESOURCE Roles
9 Assign Role to User
10 Change User password
11 Column-Level Object Privileges
12 Common System Privileges
13 Create a user and drop it
14 Create a user and grant the permission
15 Create a user and then drop it
16 Create a user, grant permission and alter its password
17 Create an outline
18 Create an outline and query user_outlines table
19 Create synonym for a view
20 Create synonym for table
21 Create synonyms for dropped tables
22 Create user
23 Create user and assign password
24 Create user chris identified by chris
25 Create User demo
26 Create user, grant permission and drop user
27 Creating a Private Synonym
28 Creating a profile with the time period for locking the account
29 Creating a Public Synonym
30 Creating a Role
31 Define a role as a global role, which means that a user can only be authorized to use the role by an enterprise directory
32 Directory privileges
33 Display current user
34 Drop public synonym
35 Drop Role
36 Drop synonym addresses
37 Drop the user if it exists
38 Get current user
39 Get current user name
40 Get two database users and show their roles
41 Get user name from all_users
42 Grant a system privilege to PUBLIC
43 Grant all on directory DirName to User
44 Grant create related permission
45 Grant CREATE SESSION privilege to a user, hr, allowing hr to log on to an Oracle database
46 GRANT CREATE SESSION TO newUserName in order to log in
47 Grant INSERT and UPDATE privileges at a column level
48 Grant one type or all types of privileges at once on any given object
49 Grant permission for a table to a user
50 Grant permission to system
51 Grant Permissions
52 Grant permissions and then check the dba_col_privs table
53 Grant Permissions to Role
54 Grant select on a table with synonym
55 Grant the CREATE TABLE privilege to DROPME
56 Grant update permission
57 Grant with user name and table name
58 If Tom owns a table Use the CASCADE keyword to drop it
59 Make a password expire with the ALTER USER command
60 Materialized view privileges
61 Output session roles from procedure
62 Procedure, function, and package privileges
63 Remove user
64 Revoke Permissions
65 Revoke Permissions with Cascade
66 REVOKE REFERENCES ON Employee FROM Bob
67 Revoking Object Privileges
68 Revoking roles
69 Select uid Current UID
70 Sequence privileges
71 Table privileges
72 Turning Auditing Off
73 Turning Auditing On in the Database
74 Unassign Role
75 Unassign Role from User
76 Unlock user
77 Use a password when a role is authorized by the database
78 Use current user name in where clause
79 Use schema in stored procedure
80 View privileges
81 Viewing synonyms and what they reference