|
-
Hi
First of all, do not use the Enterprize Managerif you ar a begginer! better use cmand line first to gain the understanding of it all.
second, look at te oracle documentation. you will find there how to:
1. create a new user (like sysman, only you need to create a new user without sysadmin priveleges). look at the grant part in te documentation very carfuly, and read it more then once. i know i had t read it more ten once until i could master the thing... first better not craate a new tablespace or datafile! eter use user_data tabel space.
2. create a new object, be it a table. index, procedur, function ... . when you whant to create a new object unfder your new user you need to connect user_name/password@...
and only then create the object! remmeber you need to think on a lt of parameters when you create a ew object, must of them will not be so clear at first, read, read and hen read again the documentation, and then ask again and again. this i te only way to learn!!! i sometims post questions n this forum that later i'm thinking way havent i look at the doc mysef first, or what the ... i was thinking f at thatpoint? it is ok! it happens to all of us
3. if you need o access the abject from a different user, you need to "grant" the object priveleges to another user. readabout that in the oracle i documentation.
as you can see you have a lot to read! and do not warry, it'll take you a long time to master it all, i know i still have alot to learn.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|