We one server on which has SQL 2000 standard edition installed on it with
sp3a .
On the server i created one login and assigned a defualt database for it,
this user is assigned only to public role .When i try to grant Insert ,
update , delete or say any rights to user on table , procedure or view  ,
they are not applied .
I have tried this through EM as well as with a query , still i am unable to
grant any rights to user.

Does anyone have any ideas about problem.

Thanks & Regards
samson

What do you mean by "they are not applied" ? DO you mean that the
statment for gtanting the right is successfull, but the user is not
able to do these Commands like INSERT, UPDATE OR Delete ? Please keep
in mind that Granted rights are commulativ, means that they are added
up, if the user is in any group with denies a right to him this will
overwrite the granted right. So please check if the user is in any
group which is denied for the appropiate commands.

HTH, jens Suessmeyer.

Yes ,right . No error was reported while doing this but the rights were not
applied.


The user is not assigned to any group .
And the user is an Sql user , we use Mixed authentication.

samson skrev:

What about denied rights in role(s) then?

    /impslayer, aka Birger Johansson

SQL 2005 unrestricted log file
SQL Server Enterprise Manager Error
SQL2K Function Print
Error inserting into iSeries DB2 table with long name via SQL Server 2000 linked Server
Trying to create a maintenance plan
CLR integration & clustering....question
MSDTC Error
how to simplify what i'm doing (AS the solution?)
Backup
Changing the database from MSAccess to MSSQLServer.