-
Hello....Help Me please........
Oracle 8: How, can I create one user that can read only one table on my database and other user that can write only one table?
Tanks!!
-
Hi,
1- Just create a user, grant him the 'connect' role, and them grant him 'select on owner.table'...
2 - same thing with 'grant insert into owner.table'
I suggest you use roles, which can be useful if you plan to have other users with same privileges.
You can them grant these roles to future users...
Hope it helps
Cheers
Fabien
-
just create one table in that user
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
|