Home » Other » General » Creating a new DB user and set authorizations
Creating a new DB user and set authorizations [message #103072] Mon, 27 January 2003 08:23 Go to next message
Rainer Reitz
Messages: 2
Registered: October 2002
Junior Member
Hi,

how can I define a new User und limit the access-rights to certain tables/fields & read/write?

Is there any good Internet-source???

Thanks,
Rainer
Re: Creating a new DB user and set authorizations [message #103122 is a reply to message #103072] Tue, 11 February 2003 17:46 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
1. Login into SQL*PLus as users with DBA privileges:

SQL>connect system/manager

2. Create the user:

SQL>CREATE USER "username" IDENTIFIEED BY "password" DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;

3. Grant him CONNECT and RESOURCE privileges:

SQL>GRANT CONNECT, RESOURCE to "username";

4. By default he doesn't have rights to query/modify anybody's objects, so you have to grant on object bases:

SQL>GRANT SELECT on "username1"."tablename1" TO "username";

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: Scripts to create a Database on Ora 8.1.7
Next Topic: Upgrade Standard edition function-based index
Goto Forum:
  


Current Time: Thu Mar 28 12:02:35 CDT 2024