Hello, mssql Gurs.
i'm using MSSQL Server 2000 SP2, Enterprise Edition.
Permissions on what objects may i revoke from public role for maximum
security (without server falling) ?
Thanks in advance, Natalia Mirochnick
Wayne Snyder, SQL Server MVP
Computer Education Services Corporation (CESC), C*te, NC
I support the Professional Association for SQL Server and its community.
I support the Professional Association for SQL Server (PASS) and its user
community of SQL Server Professionals.
My environment is SQL7 SP3, using NT security, within an NT 4.0 SP6 LAN.
When logins are added to the server, these logins are automatically
members of the
public database role. The public role is set to have select permissions
tables within many databases on the server. These tables are replicated
to another SQL server into the same database names. When the server is
rebooted, the public role loses its select permission on some(not all)
of these replicated tables. Has anyone else seen this or have any ideas
of the cause? Thanks.
2. alter index
9. public role
11. Public Role