Re: Complete Neophyte Question(s) ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ...GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ... (microsoft.public.sqlserver.security)
Re: Removing Permissions from the public role ... did you think about putting those 8 tables in a different schema, and then just granting rights to that schema, revoking the rights for that group from public. ... that user and ran some grant scripts to allow them to select from the 8 ... I see that there is a public role... the public security role is still allowing the new login access to all ... (microsoft.public.sqlserver.setup)
Re: No db access after publishing web site ...GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login.... Are you detaching/attaching the SQL Server Express database correctly ... (microsoft.public.dotnet.framework.aspnet)
Re: Normal user login now logs off immediately [w/o administrator ... The login begins in a normal fashion: ... >> problem I happened to give my normal user account administrator rights,... > Right click on MountedDevices and select "Permissions".... Thanks for the reply WTC.... (microsoft.public.windowsxp.general)
Re: Normal user login now logs off immediately [w/o administrator righ ... > My normal user account under XP Pro SP2 (which has no administrator ... The login begins in a normal fashion: ... > problem I happened to give my normal user account administrator rights,... (microsoft.public.windowsxp.general)
