| still doubt in roles [message #23073] |
Sat, 16 November 2002 01:26  |
sha
Messages: 84
Registered: July 2002
|
Member |
|
|
Hi,
If I grant connect,resoure to user then, when Iconnect to that user.I am able to insert,update etc.I want to restrict that user with some privileges.How to do that?User should not have the permissions to create or alter,drop tables or views etc.Iwant to give only select and update permission to the new user.
One more doubt,I have some tables.When Icreate those tables should be visible for all the newly created users?
thanx in advance
regards,
Shastri
|
|
|
|
| Re: still doubt in roles [message #23076 is a reply to message #23073] |
Sat, 16 November 2002 08:49  |
Chandan Singh
Messages: 14
Registered: July 2002
|
Junior Member |
|
|
Regarding your first Question
Restricting user from some privileges.Give user only those privileges that u want to give like
Grant create,drop to username.
Or
Give these privileges to Role by creating roles first then assiging these privileges to roles and then assiging these roles to Users. Roles help in assiging privileges to many user.
Regarding Your Q2
U can grant select on those tables to Public
Grant select on tablename to public. But u must have grant privilege to grant this privilege
I hope This will clear your doubt. If Not just mail me. I will try to make it Clear.
Bye
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
