Detecting local system account

Detecting local system account

Post by Tumurbaatar S » Sun, 27 Jan 2002 06:44:14



As I understand sys/dbowner users
have all permissions on db. And there's
no way to limit this. Yes?
But I need to grant DELETE permission (not insert/update)
for some table to system local account only which runs SQL Server Agent.
Other real (interactive) users should be not able to delete records.
Only sheduled job runned by Agent can delete records. How to do this?
Also is there a way to determine within a stored procedure who is
running it: system account or just user?
 
 
 

1. confusion between local system account and this account in services log on as

BOL states that the local system account is limited to network
rights,replication,etc.
What is the local system account ?

If i have a server that is a member server of the domain and the server is
logged on with a domain account , is this account the local system account ?
Which user holds the local system account ?

Our n/w guys says its the user who logs on to the system ?

What if no one logs on as when the server has just been restarted and nobody
logs on, the services still do start up . What account do they start up then
?

What replication factors are limited if the services do start with a local
system account ?

Ive set up transactional replication to another server and it seems to work
fine with the SQL Services log on a local system accout but the server is
logged on with a domain account

btw i am using SQL 7 and NT4

Thanks

2. ORA-01400

3. Service Account vs. Local System Account

4. Problem with issuing PERMIT command in Express Object

5. What is @@ERROR ?

6. Local System Account or Domain Account For SQL Server Service

7. NJ-Florham Park-94079--C-C++-Client/Server-HP-UX-UNIX-Programmer Analyst

8. Cluster shares and local system account access

9. SQL Mail and Local System Account

10. Tasks not running when SQL Executive using local system account

11. Giving Local System Account Access to SQL2k database

12. SQLAgent Service receiveing tran replication can start with local system account