Discover grant privileges to user in oracle 11g, include the articles, news, trends, analysis and practical advice about grant privileges to user in oracle 11g on alibabacloud.com
User management in Ubuntu (5) grant regular user system administrator permissions Related links: Ubuntu User Management (a) user account http://www.2cto.com/ OS /201207/143927.html?ubuntuin user management (2) Group management htt
privileges to change the user's remote permissions for some libraries Syntax templates: Grant All Privileges on to ' User name '@'IP address 'by' password 'with Grantoption;
privileges; Library Name: The name of the database to be accessed remotely, all databases use t
name in the command line: su-other_user
To return to your original user identity, use the exit command.
When you want some users to execute commands that require Super User Permissions, you can tell them the root user's password and they can use the su command to enter the root user and execute the corresponding commands.
(2)
User Management In Ubuntu (5) link to granting system administrator privileges to regular users: User Management In Ubuntu (1) User Account Management (2) Group Management http://www.bkjia.com/ OS /201207/143929.html#tu's user management (3)
1 syntaxGrant permission 1, permission 2,... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';1.1 PermissionsIf you want to grant all permissions for the user to manipulate the database tables, then permissions 1, permissions 2,... Permission N"is changed t
Known: The test user tuser1, the test role trole1, and trole1 have been authorized to tuser1.
Latency is required for testing a program, so dbms_lock is authorized to trole1 and put in an anonymous block for testing:
SQL> set serveroutput on;
But an error is returned when you move it to the function:
Connected to Oracle Database 11g Enterprise Edition Release 1
user authorization and management. The practice is to group users by their functions, create roles for each user, and assign roles to users. users with the same roles have the same privileges.
2.2 user management
The content of ORACLE u
How can I create a user in Oracle and grant specific permissions ?, Oracle Permissions
This article is edited by the Markdown syntax editor.1. Demand proposal
When HIS is integrated with a third-party system, a third-party system needs to access the view of HIS database rather than all the database tables.
The HIS dat
Authorized users can access database objects and their contents. Prompt that after a user has the permission to Process Tables of other users, the user must have public or private synonyms of these tables before he can reference tables of other users in SQL statements, oracle can identify these tables through them.
Assume that Jrstocks has a table named sample_ B
.
Although only users with sysdba and role permissions are saved in the password file, other users are also affected.
1.2 example
Here we conduct a test on Oracle 10 Gb. To avoid the impact of OS authentication, we can disable OS authentication here.
Oracle OS authentication password file and password loss
Http://blog.csdn.net/tianlesoftware/article/details/4698293
SQL> select * from V $ version;
Banner
Blogger tested on Oracle 11g R2 (test date: 2017.10.30):Log in to Oracle with SYS and execute the following two statements: Select * from WHERE like ' CONNECT '; -- Querying permissions for the Connect role Select * from WHERE like ' RESOURCE '; -- querying permissions for resource rolesConnect role:--is the typical right to
Note:1. When Oracle8.1.6 is installed in WIN2000 to create a database, a credential retrieval failure error often occurs. This is because Oracle cannot apply OS authentication results. You can modify sqlnet. AUTHENTICATION _ SERVICES in SQLNET. ora to NONE. In this case, Oracle uses Password File authentication.2. Since Oracle has several pre-built users, it is b
In Oracle databases, user permissions are divided into two types (here we do not discuss dba or dbopr permissions, but only the permissions of common users ), system Privilege System permission and User Table Privilege User data Table permission. 1. First, create a user. Th
Three default system users
Username and password
Sys change_on_install (highest Network Administrator)
Manager system local administrator
Scott tiger common user
1. Start the cmd command of the Oracle listener:
1: name of the lsnrctl start listener (not to be written)
2: Start the data instance oradim-startup-sid dataname (Instance name)
2. Log On with the highest user
Execute on to User1 Table Space Alter User default tablespace app; Restrict modified columns Grant Update on to User1 Revoke permissions Revoke Insert on from User1 Third, other aspects What permissions the role has Select * from where role='xujin'; What permissions the user has Select * from where grantee=Upper(' us
deletions cannot be controlled to columnsInsert update insert with commit requiredTransfer of permissionsSystem permissions are passed:Grant ALTER TABLE to A with admin option;Then a can pass this permission to B, if you want B can also be passed down so can also take with admin optionGrant ALTER TABLE to B;Object permissions are passed:Grant SELECT on Mytab to A with GRANT option;Then a can give the SELECT permission in table Mytab to B, and if b wa
$.password or user$. SPARE4, but the two differ in the size of the password, the specific test is as follows:
Create a test user Xifenfei[Oracle@localhost ~]$ SSSql*plus:release 11.2.0.4.0 Production on Fri APR 10 16:00:03 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database
New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp in the Development Library
2. Delete the Test Database
SYSDBA and Oper permissions are saved in the password file, other users will also be affected.1.2ExampleHere we do a test on Oracle 10g, in order to avoid the impact of OS certification, we can disable OS authentication here.Oracle OS certified password file loss handlinghttp://blog.csdn.net/tianlesoftware/article/details/4698293Sql> select * from V$version;BANNER----------------------------------------------------------------
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.