textnow users

PL/SQL creates tablespaces, creates users, and authorizes users.DeclareusrName varchar2 (20): = 'username'; pwd varchar2 (20): = 'Password'; tsName varchar2 (20): = 'xmszcgl _ aid '; dfPath varchar2 (300): = 'd: \ dataSource \ xmszcgl_aid.data '; tmpStr varchar2 (300); isDelUsrAndTs boolean: = false; begin www.2cto.comIf isDelUsrAndTs thentmpStr: = 'drop user' | usrName | 'cascade '; execute immediate tmpStr; tmpStr: = 'drop tablespace' | tsName | 'in

Query the table space Path: Select * From dba_data_files Instance: 1. Create tablespace ucitdb_data Logging Datafile '/home/APP/Oracle/oradata/ucitdb/ucitdb_data01.dbf' Size 32 m Autoextend on Next 32 m maxsize 2048 m Extent management local; Create a tablespace Ucitdb_data: User tablespace 2. Create user ucitdba identified by 111111. Default tablespace ucitdb_data; Create an account and set the default tablespace Ucitdba: Account name created 111111:

-- Select * From dba_users; queryDatabaseAll users in -- Alter user test_select account lock; lock the user -- Alter user test_select account unlock; unlock the user -- Create user xujin identified by xujin; create a user -- Grant create tablespace to xujin; Authorize -- Grant select on tabel1 to xujin; Authorize Query -- Grant update on Table1 to xujin; -- Grant execute on procedure1 to xujin authorized Stored Procedure -- Grant update on Table1 to x

Linux adds sudo permissions to users and linux UsersLinux adds sudo permissions to users:Sometimes, if you run the sudo command in linux, the prompt is similar:Xxxis not in the sudoers file. This incident will be reported.Here, xxx is the user name, and thus the sudo command cannot be executed. At this time, the following solution is taken: Enter the superuser mode. That is, enter "su-". The system will ask you to enter the superuser password and

. Turn off password-protected sharing (this will avoid entering a password when exchanging visits). 4. Allow the family group to connect For folders that need to be fully shared to XP under Windows 7, you can right-click the folder and select shared/specific users, enter everyone or guest in the input box, and then click the Add button after adding to the list to change the user's permissions to read/write. Shared Settings for XP Configure a netwo

Data cleansing Note: When multiple users call the same function, note that multiple users Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to pursue legal liability for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/46340515 Background] During data extraction, w

Centos adds 2009-12-1612: 56 [1] system logon and exit samplelogin: root larr; to log on to the system as the root user and enter the username rootPassword: larr; enter the root password set during installation here, and the password will not be displayed when you enter [added general users in centos and logon and logout of the system for users in the wheel group [1] Sample login: root

1. First of all, to understand the needs of customers in the future is to interview. Only in the interview can you have sufficient contact with the customer to understand the needs of users.General interviews include formal interviews and informal interviews. In formal interviews, system analysts usually ask questions that are pre-prepared. To determine the size of the user's needs and prepare for subsequent development. In informal interviews, the system analyst raises questions that some

The so-called efficiency ... See SAE Fee method. The less expensive the better. / http sae.sina.com.cn/? m=devcentercatid=155 Reply content:Two are not good, can be based on the UID hash table or based on the time line hash table. See the definition of specific requirements What is the order of magnitude, 10,000, 100,000, million, tens of millions? How big is the amount of data per user? What is the ratio of active and inactive users? What

Javaweb development, sometimes encountered statistics or management user login number or current online how many users, respectively, who is the case. Of course, there are many ways to achieve. The following is a list of statistics that are implemented by the session. Public classMysessionlistenerImplementsHttpsessionlistener {/*** Create session*/@SuppressWarnings ({"Rawtypes", "unchecked" }) Public voidsessioncreated (Httpsessionevent event) {Htt

Label:Oracle create user, grant permissions, and delete user create user Oracle to tablespace users without permission alter user username quota unlimited on users;Creating a temporary tablespace create temporary tablespace test_temp tempfile ' E:/oracle/product/10.2.0/oradata/testserver/test_temp01.dbf ' size 32m autoextend on next 32m maxsize 2048m extent management local; Creating a data table space crea

Create user Oracle to tablespace users without permission alter user username quota unlimited on users; Creating a temporary tablespace create temporary tablespace test_temp tempfile ' E:/oracle/product/10.2.0/oradata/testserver/test_temp01.dbf ' size 32m autoextend on next 32m maxsize 2048m extent management local; Creating a data table space create tablespace test_data logging www.2cto.com datafile ' e

1--Detect orphaned users and restore orphaned users to new server to resolve database mirroring orphaned users problem 2--note: Relink can only link to the SQL login account, cannot link Windows login account 3-- If you do not select Relink to restore to a new server by using the backup master database, you can avoid a database that has 4--hundreds of thousands o