webstore.sql

噶额外噶外骨骼感广泛高热感 就 啊啊

SET SCAN ON

PROMPT Enter the password and TNS name.
PROMPT Enter the oracle SID for TNS name if you are running a local database.

CONNECT system/&systempassword@&&tnsname

-- Drop the user and all other related objects.
DROP USER webstore CASCADE;

-- Creating the schema
CREATE USER webstore IDENTIFIED BY welcome;

-- Grant the permissions to the user.
GRANT RESOURCE, CONNECT TO webstore;


ALTER USER webstore DEFAULT TABLESPACE users
              QUOTA UNLIMITED ON users;

ALTER USER webstore TEMPORARY TABLESPACE temp;

COMMIT;