Re: [SQL] User Permission

2006-07-19 Thread Richard Broersma Jr
> > Dear group, > >i created a user named 'dataviewer' and grant only select permission to > > that user, > >but now the user could able to create tables. how to restrict this, > >i want to give permission to create views and do selects on tables and > > views. > >how to do it? > >

Re: [SQL] User Permission

2006-07-19 Thread Aaron Bono
On 7/19/06, sathish kumar shanmugavelu <[EMAIL PROTECTED]> wrote: Dear group,   i created a user named 'dataviewer' and grant only select permission to that user,   but now the user could able to create tables. how to restrict this,   i want to give permission to create views and do selects on tabl

[SQL] User Permission

2006-07-19 Thread sathish kumar shanmugavelu
Dear group,   i created a user named 'dataviewer' and grant only select permission to that user,   but now the user could able to create tables. how to restrict this,   i want to give permission to create views and do selects on tables and views.    how to do it?   plz help.-- Sathish Kumar.SSpireT